Spreadsheet: 861185d1709136620-rollings-sumifs-with-multiple-criteria-sample_sumifs_rolling_multiple-criteria-etaf
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1
Transaction Date | Customer / Supplier | Reference | Description | Inclusive Amount | Tax 1 Code | Tax 2 Code | Bank Code | Account Number | Statement Date | Trn Type | Cashbook Balance | Sales Tax 1 Amount | Sales Tax 2 Amount | Exclusive Amount | Cashbook Balance Date | Error Code | Cashbook Balance
2020-02-28 00:00:00 | Opening | O/B | Opening Bank Statement Balance | 3400 | E | E | B1 | BS-TRF | 2020-02-28 00:00:00 | D | 3400 |  |  |  |  |  |  | < this should say 3400
2020-02-28 00:00:00 | Opening | O/B | Opening Bank Statement Balance | 1600 | E | E | B2 | BS-TRF | 2020-02-28 00:00:00 | D | 1600
2020-02-28 00:00:00 | Opening | O/B | Opening Bank Statement Balance | 0 | E | E | B3 | BS-TRF | 2020-02-28 00:00:00 | D | 0
2020-02-28 00:00:00 | Opening | O/B | Opening Petty Cash Balance | 1000 | E | E | PC | BS-TRF | 2020-02-28 00:00:00 | D | 1000
2020-03-02 00:00:00 | XY Solutions | Invoice EXP09 | Internet Service Provider | -165.3 | A | E | B1 | IS-380 | 2020-03-02 00:00:00 | W | 3234.7
2020-03-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-03-05 00:00:00 | W | 2869.9
2020-03-10 00:00:00 | WS Wholesale | INV0052 | Consulting Services | 17100 | A | E | B1 | IS-100 | 2020-03-10 00:00:00 | D | 19969.9
2020-03-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-03-15 00:00:00 | W | 19912.9
2020-03-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 8000 | E | E | B2 | BS-TRF | 2020-03-20 00:00:00 | D | 9600
2020-03-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -8000 | E | E | B1 | BS-TRF | 2020-03-20 00:00:00 | W | 11912.9
2020-03-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -210 | E | E | B1 | BS-TRF | 2020-03-25 00:00:00 | W | 11702.9
2020-03-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 210 | E | E | PC | BS-TRF | 2020-03-25 00:00:00 | D | 1210
2020-03-26 00:00:00 | Payroll | Payroll | Salaries | -8000 | E | E | B2 | IS-365 | 2020-03-26 00:00:00 | W | 1600
2020-03-26 00:00:00 | PR Properties | [NAME] | Rent | -5700 | A | E | B1 | IS-350 | 2020-03-26 00:00:00 | W | 6002.900000000001
2020-03-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-03-26 00:00:00 | W | 5902.900000000001
2020-03-31 00:00:00 | XY Solutions | Invoice EXP10 | Internet Service Provider | -165.3 | A | E | B1 | IS-380 | 2020-03-31 00:00:00 | W | 5737.600000000001
2020-04-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-04-02 00:00:00 | W | 4825.600000000001
2020-04-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-04-05 00:00:00 | W | 4460.800000000001
2020-04-10 00:00:00 | Waltons | Invoice | Paper | -224 | A | E | PC | IS-325 | 2020-04-10 00:00:00 | W | 986
2020-04-13 00:00:00 | GP Accountants | INV0054 | Consulting Services | 9291 | A | E | B1 | IS-100 | 2020-04-13 00:00:00 | D | 13751.8
2020-04-14 00:00:00 | TRF Solutions | INV0053 | Consulting Services | 12768 | A | E | B1 | IS-100 | 2020-04-14 00:00:00 | D | 26519.8
2020-04-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-04-15 00:00:00 | W | 26462.8
2020-04-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 8000 | E | E | B2 | BS-TRF | 2020-04-20 00:00:00 | D | 9600
2020-04-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -8000 | E | E | B1 | BS-TRF | 2020-04-20 00:00:00 | W | 18462.8
2020-04-24 00:00:00 | Waltons | Invoice | Paper | -228 | A | E | PC | IS-325 | 2020-04-24 00:00:00 | W | 758
2020-04-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -320 | E | E | B1 | BS-TRF | 2020-04-25 00:00:00 | W | 18142.8
2020-04-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 320 | E | E | PC | BS-TRF | 2020-04-25 00:00:00 | D | 1078
2020-04-25 00:00:00 | Inland Revenue | Return | Sales Tax | -2700 | E | E | B1 | BS-TAX1 | 2020-04-25 00:00:00 | W | 15442.8
2020-04-26 00:00:00 | Payroll | Payroll | Salaries | -8000 | E | E | B2 | IS-365 | 2020-04-26 00:00:00 | W | 1600
2020-04-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-04-26 00:00:00 | W | 9742.8
2020-04-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-04-26 00:00:00 | W | 9642.8
2020-04-27 00:00:00 | WC Financial Advisors | [NAME] | Taxation Services | 7979.999999999999 | A | E | B1 | IS-100 | 2020-04-27 00:00:00 | D | 17622.8
2020-04-27 00:00:00 | WC Financial Advisors | [NAME] | Accounting Services | 3762 | A | E | B1 | IS-100 | 2020-04-27 00:00:00 | D | 21384.8
2020-04-27 00:00:00 | WC Financial Advisors | [NAME] | Consulting Services | 37777.32 | A | E | B1 | IS-100 | 2020-04-27 00:00:00 | D | 59162.12
2020-05-01 00:00:00 | XY Solutions | Invoice EXP11 | Internet Service Provider | -165.3 | A | E | B1 | IS-380 | 2020-05-01 00:00:00 | W | 58996.81999999999
2020-05-03 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-05-03 00:00:00 | W | 58084.81999999999
2020-05-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-05-05 00:00:00 | W | 57720.01999999999
2020-05-08 00:00:00 | ABC Limited | INV0055 | Accounting Services | 17100 | A | E | B1 | IS-100 | 2020-05-08 00:00:00 | D | 74820.01999999999
2020-05-08 00:00:00 | Waltons | Invoice | Paper | -228 | A | E | PC | IS-325 | 2020-05-08 00:00:00 | W | 850
2020-05-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-05-15 00:00:00 | W | 74763.01999999999
2020-05-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-05-20 00:00:00 | D | 14600
2020-05-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-05-20 00:00:00 | W | 61763.01999999999
2020-05-22 00:00:00 | PQW Parking | TR5674 | Parking | -641.8199999999999 | A | E | B1 | IS-390 | 2020-05-22 00:00:00 | W | 61121.19999999999
2020-05-22 00:00:00 | Waltons | Invoice | Paper | -228 | A | E | PC | IS-325 | 2020-05-22 00:00:00 | W | 622
2020-05-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -250 | E | E | B1 | BS-TRF | 2020-05-25 00:00:00 | W | 60871.19999999999
2020-05-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 250 | E | E | PC | BS-TRF | 2020-05-25 00:00:00 | D | 872
2020-05-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-05-26 00:00:00 | W | 1600
2020-05-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-05-26 00:00:00 | W | 55171.19999999999
2020-05-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-05-26 00:00:00 | W | 55071.19999999999
2020-05-27 00:00:00 | LS Retail | X9987 | Commission Received | 5962.2 | A | E | B1 | IS-200 | 2020-05-31 00:00:00 | D | 61033.39999999999
2020-05-31 00:00:00 | XY Solutions | Invoice EXP12 | Internet Service Provider | -165.3 | A | E | B1 | IS-380 | 2020-05-31 00:00:00 | W | 60868.09999999998
2020-06-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-06-02 00:00:00 | W | 59956.09999999998
2020-06-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-06-05 00:00:00 | W | 59591.29999999998
2020-06-05 00:00:00 | Waltons | Invoice | Paper | -228 | A | E | PC | IS-325 | 2020-06-05 00:00:00 | W | 644
2020-06-10 00:00:00 | SQ Financial Services | Statement | Loan Received | 8100 | E | E | B1 | BS-700 | 2020-06-10 00:00:00 | D | 67691.29999999999
2020-06-11 00:00:00 | XX Building Supplies | INV0057 | Accounting Services | 4560 | A | E | B1 | IS-100 | 2020-06-11 00:00:00 | D | 72251.29999999999
2020-06-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-06-15 00:00:00 | W | 72194.29999999999
2020-06-15 00:00:00 | Finance Week | Bank Statement | Annual Subscription | -1368 | A | E | B1 | IS-375 | 2020-06-15 00:00:00 | W | 70826.29999999999
2020-06-19 00:00:00 | Waltons | Invoice | Paper | -228 | A | E | PC | IS-325 | 2020-06-19 00:00:00 | W | 644
2020-06-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-06-20 00:00:00 | D | 14600
2020-06-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-06-20 00:00:00 | W | 57826.29999999999
2020-06-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -200 | E | E | B1 | BS-TRF | 2020-06-25 00:00:00 | W | 57626.29999999999
2020-06-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 200 | E | E | PC | BS-TRF | 2020-06-25 00:00:00 | D | 616
2020-06-25 00:00:00 | Inland Revenue | Return | Sales Tax | -5000 | E | E | B1 | BS-TAX1 | 2020-06-25 00:00:00 | W | 52626.29999999999
2020-06-25 00:00:00 | XR Supplies | Invoice | Computer equipment | -5700 | A | E | B1 | BS-100 | 2020-06-25 00:00:00 | W | 46926.29999999999
2020-06-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-06-26 00:00:00 | W | 1600
2020-06-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-06-26 00:00:00 | W | 41226.29999999999
2020-06-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-06-26 00:00:00 | W | 41006.29999999999
2020-06-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-06-26 00:00:00 | W | 40906.29999999999
2020-06-26 00:00:00 | TRF Solutions | INV0058 | Accounting Services | 15276 | A | E | B1 | IS-100 | 2020-06-26 00:00:00 | D | 56182.29999999999
2020-07-01 00:00:00 | WW Retail | INV0059 | Taxation Services | 5130 | A | E | B1 | IS-100 | 2020-07-01 00:00:00 | D | 61312.29999999999
2020-07-01 00:00:00 | XY Solutions | Invoice EXP13 | Internet Service Provider | -165.3 | A | E | B1 | IS-380 | 2020-07-01 00:00:00 | W | 61146.99999999999
2020-07-03 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-07-03 00:00:00 | W | 60234.99999999999
2020-07-03 00:00:00 | Waltons | Invoice | Paper | -250.173 | A | E | PC | IS-325 | 2020-07-03 00:00:00 | W | 365.827
2020-07-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-07-05 00:00:00 | W | 59870.19999999998
2020-07-11 00:00:00 | PQW Parking | TR5982 | Parking | -229.14 | A | E | B1 | IS-390 | 2020-07-11 00:00:00 | W | 59641.05999999998
2020-07-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-07-15 00:00:00 | W | 59584.05999999998
2020-07-17 00:00:00 | SPAR | IN1123 | Consumables | -111.72 | A | E | PC | IS-325 | 2020-07-17 00:00:00 | W | 254.107
2020-07-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-07-20 00:00:00 | D | 14600
2020-07-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-07-20 00:00:00 | W | 46584.05999999998
2020-07-23 00:00:00 | DF Manufacturing | INV0060 | Accounting Services | 3192 | A | E | B1 | IS-100 | 2020-07-23 00:00:00 | D | 49776.05999999998
2020-07-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -280 | E | E | B1 | BS-TRF | 2020-07-25 00:00:00 | W | 49496.05999999998
2020-07-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 280 | E | E | PC | BS-TRF | 2020-07-25 00:00:00 | D | 534.107
2020-07-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-07-26 00:00:00 | W | 1600
2020-07-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-07-26 00:00:00 | W | 49496.05999999998
2020-07-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-07-26 00:00:00 | W | 43576.05999999998
2020-07-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-07-26 00:00:00 | W | 43476.05999999998
2020-07-31 00:00:00 | DF Manufacturing | INV0062 | Consulting Services | 25080 | A | E | B1 | IS-100 | 2020-07-31 00:00:00 | D | 68556.05999999998
2020-07-31 00:00:00 | XY Solutions | Invoice EXP14 | Internet Service Provider | -165.3 | A | E | B1 | IS-380 | 2020-07-31 00:00:00 | W | 68390.75999999998
2020-08-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-08-02 00:00:00 | W | 67478.75999999998
2020-08-04 00:00:00 | Digicom | INV0061 | Consulting Services | 36480 | A | E | B1 | IS-100 | 2020-08-04 00:00:00 | D | 103958.76
2020-08-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-08-05 00:00:00 | W | 103593.96
2020-08-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-08-15 00:00:00 | W | 103536.96
2020-08-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-08-20 00:00:00 | D | 14600
2020-08-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-08-20 00:00:00 | W | 90536.95999999998
2020-08-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -190 | E | E | B1 | BS-TRF | 2020-08-25 00:00:00 | W | 90346.95999999998
2020-08-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 190 | E | E | PC | BS-TRF | 2020-08-25 00:00:00 | D | 724.107
2020-08-25 00:00:00 | Inland Revenue | Return | Sales Tax | -5900 | E | E | B1 | BS-TAX1 | 2020-08-25 00:00:00 | W | 84446.95999999998
2020-08-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-08-26 00:00:00 | W | 1600
2020-08-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-08-26 00:00:00 | W | 78746.95999999998
2020-08-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-08-26 00:00:00 | W | 78526.95999999998
2020-08-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-08-26 00:00:00 | W | 78426.95999999998
2020-08-27 00:00:00 | MM Brokers | O/B S77782 | Investment in Shares | -5100 | E | E | B1 | BS-200 | 2020-09-02 00:00:00 | W | 73326.95999999998
2020-08-30 00:00:00 | PQW Parking | TR6290 | Parking | -202.92 | A | E | B1 | IS-390 | 2020-08-30 00:00:00 | W | 73124.03999999998
2020-08-31 00:00:00 | XY Solutions | Invoice EXP15 | Internet Service Provider | -204.06 | A | E | B1 | IS-380 | 2020-08-31 00:00:00 | W | 72919.97999999998
2020-09-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-09-02 00:00:00 | W | 72007.97999999998
2020-09-03 00:00:00 | FS Financial Services | INV0063 | Consulting Services | 26220 | A | E | B1 | IS-100 | 2020-09-03 00:00:00 | D | 98227.97999999998
2020-09-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-09-05 00:00:00 | W | 97863.17999999998
2020-09-06 00:00:00 | RT Office Supplies | T2518536 | Office chair | -1821.72 | A | E | B1 | IS-345 | 2020-09-06 00:00:00 | W | 96041.45999999998
2020-09-12 00:00:00 | PTY Consultants | INV0064 | Consulting Services | 13680 | A | E | B1 | IS-100 | 2020-09-12 00:00:00 | D | 109721.46
2020-09-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-09-15 00:00:00 | W | 109664.46
2020-09-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-09-20 00:00:00 | D | 14600
2020-09-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-09-20 00:00:00 | W | 96664.45999999998
2020-09-21 00:00:00 | Town Council | Statement | Rates | -4752 | E | E | B1 | IS-395 | 2020-09-21 00:00:00 | W | 91912.45999999998
2020-09-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -330 | E | E | B1 | BS-TRF | 2020-09-25 00:00:00 | W | 91582.45999999998
2020-09-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 330 | E | E | PC | BS-TRF | 2020-09-25 00:00:00 | D | 1054.107
2020-09-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-09-26 00:00:00 | W | 1600
2020-09-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-09-26 00:00:00 | W | 85882.45999999998
2020-09-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-09-26 00:00:00 | W | 85662.45999999998
2020-09-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-09-26 00:00:00 | W | 85562.45999999998
2020-10-01 00:00:00 | XY Solutions | Invoice EXP16 | Internet Service Provider | -204.06 | A | E | B1 | IS-380 | 2020-10-01 00:00:00 | W | 85358.39999999998
2020-10-03 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-10-03 00:00:00 | W | 84446.39999999998
2020-10-04 00:00:00 | SPAR | IN1145 | Consumables | -59.27999999999999 | A | E | PC | IS-325 | 2020-10-04 00:00:00 | W | 994.827
2020-10-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-10-05 00:00:00 | W | 84081.59999999998
2020-10-09 00:00:00 | IT Solutions | INV0065 | Consulting Services | 20520 | A | E | B1 | IS-100 | 2020-10-09 00:00:00 | D | 104601.6
2020-10-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-10-15 00:00:00 | W | 104544.6
2020-10-19 00:00:00 | PQW Parking | TR6598 | Parking | -3420 | A | E | B1 | IS-390 | 2020-10-19 00:00:00 | W | 101124.6
2020-10-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-10-20 00:00:00 | D | 14600
2020-10-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-10-20 00:00:00 | W | 88124.59999999998
2020-10-21 00:00:00 | DF Manufacturing | INV0066 | Consulting Services | 15390 | A | E | B1 | IS-100 | 2020-10-21 00:00:00 | D | 103514.6
2020-10-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -220 | E | E | B1 | BS-TRF | 2020-10-25 00:00:00 | W | 103294.6
2020-10-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 220 | E | E | PC | BS-TRF | 2020-10-25 00:00:00 | D | 1214.827
2020-10-25 00:00:00 | Inland Revenue | Return | Sales Tax | -3500 | E | E | B1 | BS-TAX1 | 2020-10-25 00:00:00 | W | 99794.59999999998
2020-10-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-10-26 00:00:00 | W | 1600
2020-10-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-10-26 00:00:00 | W | 94094.59999999998
2020-10-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-10-26 00:00:00 | W | 93874.59999999998
2020-10-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-10-26 00:00:00 | W | 93774.59999999998
2020-10-31 00:00:00 | XY Solutions | Invoice EXP17 | Internet Service Provider | -204.06 | A | E | B1 | IS-380 | 2020-10-31 00:00:00 | W | 93570.53999999998
2020-11-02 00:00:00 | GF Training | Invoice | Course | -769.4999999999999 | A | E | B1 | IS-385 | 2020-11-02 00:00:00 | W | 92801.03999999998
2020-11-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-11-02 00:00:00 | W | 91889.03999999998
2020-11-03 00:00:00 | GP Accountants | INV0067 | Accounting Services | 3762 | A | E | B1 | IS-100 | 2020-11-03 00:00:00 | D | 95651.03999999998
2020-11-03 00:00:00 | GP Accountants | INV0067 | Taxation Services | 2451 | A | E | B1 | IS-100 | 2020-11-03 00:00:00 | D | 98102.03999999998
2020-11-03 00:00:00 | GP Accountants | INV0067 | Secretarial Services | 1026 | A | E | B1 | IS-100 | 2020-11-03 00:00:00 | D | 99128.03999999998
2020-11-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-11-05 00:00:00 | W | 98763.23999999998
2020-11-07 00:00:00 | Economist | 628054 | Subscription | -516.7049999999999 | A | E | B1 | IS-375 | 2020-11-07 00:00:00 | W | 98246.53499999997
2020-11-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-11-15 00:00:00 | W | 98189.53499999997
2020-11-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-11-20 00:00:00 | D | 14600
2020-11-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-11-20 00:00:00 | W | 85189.53499999997
2020-11-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -290 | E | E | B1 | BS-TRF | 2020-11-25 00:00:00 | W | 84899.53499999997
2020-11-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 290 | E | E | PC | BS-TRF | 2020-11-25 00:00:00 | D | 1504.827
2020-11-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-11-26 00:00:00 | W | 1600
2020-11-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-11-26 00:00:00 | W | 79199.53499999997
2020-11-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-11-26 00:00:00 | W | 78979.53499999997
2020-11-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-11-26 00:00:00 | W | 78879.53499999997
2020-11-30 00:00:00 | CC Supplies | INV0068 | Accounting Services | 3762 | A | E | B1 | IS-100 | 2020-11-30 00:00:00 | D | 82641.53499999997
2020-12-01 00:00:00 | XY Solutions | Invoice EXP18 | Internet Service Provider | -204.06 | A | E | B1 | IS-380 | 2020-12-01 00:00:00 | W | 82437.47499999998
2020-12-03 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2020-12-03 00:00:00 | W | 81525.47499999998
2020-12-05 00:00:00 | Hollard | [NAME] | Insurance | -364.8 | A | E | B1 | IS-340 | 2020-12-05 00:00:00 | W | 81160.67499999997
2020-12-05 00:00:00 | TRF Solutions | INV0069 | Consulting Services | 17100 | A | E | B1 | IS-100 | 2020-12-05 00:00:00 | D | 98260.67499999997
2020-12-08 00:00:00 | PQW Parking | TR6906 | Parking | -228 | A | E | B1 | IS-390 | 2020-12-08 00:00:00 | W | 98032.67499999997
2020-12-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2020-12-15 00:00:00 | W | 97975.67499999997
2020-12-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2020-12-20 00:00:00 | D | 14600
2020-12-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2020-12-20 00:00:00 | W | 84975.67499999997
2020-12-22 00:00:00 | SPAR | IN1149 | Consumables | -59.27999999999999 | A | E | PC | IS-325 | 2020-12-22 00:00:00 | W | 1445.547
2020-12-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -390 | E | E | B1 | BS-TRF | 2020-12-25 00:00:00 | W | 84585.67499999997
2020-12-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 390 | E | E | PC | BS-TRF | 2020-12-25 00:00:00 | D | 1835.547
2020-12-25 00:00:00 | Inland Revenue | Return | Sales Tax | -1500 | E | E | B1 | BS-TAX1 | 2020-12-25 00:00:00 | W | 83085.67499999997
2020-12-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2020-12-26 00:00:00 | W | 1600
2020-12-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2020-12-26 00:00:00 | W | 77385.67499999997
2020-12-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2020-12-26 00:00:00 | W | 77165.67499999997
2020-12-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2020-12-26 00:00:00 | W | 77065.67499999997
2020-12-30 00:00:00 | ABC Limited | INV0070 | Consulting Services | 16986 | A | E | B1 | IS-100 | 2020-12-30 00:00:00 | D | 94051.67499999997
2020-12-31 00:00:00 | XY Solutions | Invoice EXP19 | Internet Service Provider | -204.06 | A | E | B1 | IS-380 | 2020-12-31 00:00:00 | W | 93847.61499999998
2021-01-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2021-01-02 00:00:00 | W | 93847.61499999998
2021-01-04 00:00:00 | EC Estate Agents | INV0071 | Taxation Services | 9311.519999999999 | A | E | B1 | IS-100 | 2021-01-04 00:00:00 | D | 102247.135
2021-01-05 00:00:00 | Hollard | [NAME] | Insurance | -387.6 | A | E | B1 | IS-340 | 2021-01-05 00:00:00 | W | 101859.535
2021-01-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2021-01-15 00:00:00 | W | 101802.535
2021-01-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2021-01-20 00:00:00 | D | 14600
2021-01-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2021-01-20 00:00:00 | W | 88802.53499999997
2021-01-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -250 | E | E | B1 | BS-TRF | 2021-01-25 00:00:00 | W | 88552.53499999997
2021-01-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 250 | E | E | PC | BS-TRF | 2021-01-25 00:00:00 | D | 2085.547
2021-01-25 00:00:00 | DF Manufacturing | O/B INV0051 | Consulting Services | 9120 | A | E | B1 | IS-100 | 2021-02-01 00:00:00 | D | 97672.53499999997
2021-01-25 00:00:00 | The Paint Shop | INV0072 | Taxation Services | 2793 | A | E | B1 | IS-100 | 2021-01-25 00:00:00 | D | 100465.535
2021-01-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2021-01-26 00:00:00 | W | 1600
2021-01-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2021-01-26 00:00:00 | W | 94765.53499999997
2021-01-26 00:00:00 | PTY Consultants | [NAME] | Consulting Services | 21888 | A | E | B1 | IS-100 | 2021-01-26 00:00:00 | D | 116653.535
2021-01-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2021-01-26 00:00:00 | W | 116433.535
2021-01-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2021-01-26 00:00:00 | W | 116333.535
2021-01-27 00:00:00 | Qantas | SA8234 | Travel | -1273.38 | A | E | B1 | IS-390 | 2021-02-02 00:00:00 | W | 115060.155
2021-01-27 00:00:00 | WW Retail | INV0073 | Consulting Services | 20520 | A | E | B1 | IS-100 | 2021-01-27 00:00:00 | D | 135580.155
2021-01-31 00:00:00 | XY Solutions | Invoice EXP20 | Internet Service Provider | -204.06 | A | E | B1 | IS-380 | 2021-01-31 00:00:00 | W | 135376.095
2021-02-02 00:00:00 | IAS Accountants | Invoice | Bookkeeping | -911.9999999999999 | A | E | B1 | IS-305 | 2021-02-02 00:00:00 | W | 134464.095
2021-02-05 00:00:00 | Hollard | [NAME] | Insurance | -387.6 | A | E | B1 | IS-340 | 2021-02-05 00:00:00 | W | 134076.495
2021-02-15 00:00:00 | ABSA | Bank Statement | Service Fees | -56.99999999999999 | A | E | B1 | IS-315 | 2021-02-15 00:00:00 | W | 134019.495
2021-02-17 00:00:00 | SPAR | IN1156 | Consumables | -111.72 | A | E | PC | IS-325 | 2021-02-17 00:00:00 | W | 1973.827
2021-02-18 00:00:00 | WS Wholesale | INV0075 | Consulting Services | 19365.18 | A | E | B1 | IS-100 | 2021-03-18 00:00:00 | D | 153384.675
2021-02-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | 13000 | E | E | B2 | BS-TRF | 2021-02-20 00:00:00 | D | 14600
2021-02-20 00:00:00 | Transfer | Bank Statement | Bank Transfer | -13000 | E | E | B1 | BS-TRF | 2021-02-20 00:00:00 | W | 140384.675
2021-02-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | -200 | E | E | B1 | BS-TRF | 2021-02-25 00:00:00 | W | 140184.675
2021-02-25 00:00:00 | Cash | Bank Statement | Petty Cash Reimbursement | 200 | E | E | PC | BS-TRF | 2021-02-25 00:00:00 | D | 2173.827
2021-02-25 00:00:00 | Inland Revenue | Return | Sales Tax | -3600 | E | E | B1 | BS-TAX1 | 2021-02-25 00:00:00 | W | 136584.675
2021-02-26 00:00:00 | Payroll | Payroll | Salaries | -13000 | E | E | B2 | IS-365 | 2021-02-26 00:00:00 | W | 1600
2021-02-26 00:00:00 | PR Properties | [NAME] | Rent | -5699.999999999999 | A | E | B1 | IS-350 | 2021-02-26 00:00:00 | W | 130884.675
2021-02-26 00:00:00 | SQ Financial Services | [NAME] | Capital repayment | -220 | E | E | B1 | BS-700 | 2021-02-26 00:00:00 | W | 130664.675
2021-02-26 00:00:00 | SQ Financial Services | [NAME] | Interest paid | -100 | E | E | B1 | IS-500 | 2021-02-26 00:00:00 | W | 130564.675
2021-02-28 00:00:00 | XY Solutions | Invoice EXP21 | Internet Service Provider | -351.1199999999999 | A | E | B1 | IS-380 | 2021-03-02 00:00:00 | W | 130213.555