Spreadsheet: 131842d1323355648-summing-up-various-ledger-accounts-exported-from-pastel-into-excel-test-spreadsheet
Sheet: 8.12.11

0 | AccNumber | AccDesc | BalanceThis01 | BalanceThis02 | BalanceThis03 | BalanceThis04 | BalanceThis05 | BalanceThis06 | BalanceThis07 | BalanceThis08 | BalanceThis09 | BalanceThis10 | BalanceThis11 | BalanceThis12
Cpt | 1000001 | Sales | -50
Dbn | 1000001 | Sales | -50
Grj | 1000001 | Sales | -500000
[NAME] | 1000001 | Sales - Repairs
Nam | 1000001 | Service / Fee Income
Recycle | 1000001 | Sales
Cpt | 1000002 | Repairs
Dbn | 1000002 | Quote Rejection Fee
Grj | 1000002 | Repairs
[NAME] | 1000002 | Sales - Quote Rejection Fee
Nam | 1000002 | Care Pack Revenue
 |  |  | -500100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 2750000 | Interest Received
Dbn | 2750000 | Interest Received | -0.02
Grj | 2750000 | Interest Received | -0.03
[NAME] | 2750000 | Interest Received
Nam | 2750000 | Interest Received
Recycle | 2750000 | Interest Received
 |  |  | -0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 2850000 | Bad Debts Recovered
Dbn | 2850000 | Bad Debts Recovered
Grj | 2850000 | Bad Debts Recovered
[NAME] | 2850000 | Bad Debts Recovered
Nam | 2850000 | Bad Debts Recovered
Recycle | 2850000 | Bad Debts Recovered
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dbn | 2900000 | Sundry Income
[NAME] | 2900000 | Sundry Income
Nam | 2900000 | Sundry Income
Recycle | 2900000 | Sundry Income
Cpt | 2900001 | Sundry Income - Rental Income | -4540
Grj | 2900001 | Sundry Income - Other
Cpt | 2900002 | Sundry Income - Other
Grj | 2900002 | Sundry Income - Finance, HR & Admin Fees
Grj | 2900003 | HP Setup Costs
Grj | 2900004 | W&R Seta Income | -10000
 |  |  | -14540 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | -514640.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nam | 2000000 | Operating Costs / Cost of Sales | 150
Cpt | 2000001 | Parts - Repairs | 5222
Dbn | 2000001 | Parts - Repairs | 3586
Grj | 2000001 | Parts - Repairs | 45000
[NAME] | 2000001 | Cost of Sales - Purchases
Recycle | 2000001 | Parts - Repairs
Cpt | 2000002 | Other | 2556
Dbn | 2000002 | SPL - IN Warranty | 15454
Grj | 2000002 | Other
Recycle | 2000002 | SPL - IN Warranty
Cpt | 2000003 | SPL - OUT Warranty LMR006 | 80
 |  |  | 72048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 3000000 | Accounting Fees | 100
Dbn | 3000000 | Accounting Fees | 250
Grj | 3000000 | Accounting Fees
[NAME] | 3000000 | Accounting Fees
Nam | 3000000 | Accounting Fees
Recycle | 3000000 | Accounting Fees
Dbn | 3100000 | Accounting / Audit Fees
Nam | 3100000 | Accounting / Audit Fees
Recycle | 3100000 | Accounting / Audit Fees
 |  | Subtotal | 350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 3050000 | Advertising & Promotions | 258
Dbn | 3050000 | Advertising & Promotions | 569
Grj | 3050000 | Advertising & Promotions
[NAME] | 3050000 | Advertising & Promotions
Nam | 3050000 | Advertising & Promotions
Recycle | 3050000 | Advertising & Promotions
 |  | Subtotal | 827 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 3150000 | Bad Debts
Dbn | 3150000 | Bad Debts | 250
Grj | 3150000 | Bad Debts
[NAME] | 3150000 | Bad Debts
Nam | 3150000 | Bad Debts
Recycle | 3150000 | Bad Debts
 |  | Subtotal | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 3200000 | Bank Charges | 2356
Dbn | 3200000 | Bank Charges | 154
[NAME] | 3200000 | Bank Charges | 975
Nam | 3200000 | Bank Charges
Recycle | 3200000 | Bank Charges
Grj | 3200001 | Bank Charges - General | 45644
Grj | 3200002 | Bank Charges - Nedbank Cash Solutions
 |  | Subtotal | 49129 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cpt | 3250000 | Cleaning | 250
Dbn | 3250000 | Cleaning | 250
Grj | 3250000 | Cleaning | 250
[NAME] | 3250000 | Cleaning | 250
Nam | 3250000 | Cleaning | 250
Recycle | 3250000 | Cleaning
 |  | Subtotal | 1250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Income | -514640.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | total Cost of Sales | 72048 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Subtotal | Total Expenses | 51806 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Profit / Loss | -390786.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0