Spreadsheet: 59928d1260454906-macro-to-re-arrange-auto-report-from-pivot-table-general-ledger
Sheet: Journal General

 |  | GENERAL LEDGER
 |  | DATE | A/C NAME | A/C NO | [NAME] | PARTICULARS | Debit | Credit | Balance |  |  | BANK | 1001
 |  | 2009-11-01 00:00:00 | BANK | 1001 | D | CASH RECEIVED FROM DEVID |  | 500 | -500 |  |  | LOAN | 1003
 |  | 2009-11-02 00:00:00 | LOAN | 1003 | C | PAID TO BANK FOR EXP |  | 500 | -500 |  |  | SALARIES | 1004
 |  | 2009-11-03 00:00:00 | BANK | 1001 | D | PAID TO MICHLE |  | 50 | -50 |  |  | PETROL | 1005
 |  | 2009-11-04 00:00:00 | SALARIES | 1004 | C | SAL JAN-09 MICHLE |  | 50 | -50 |  |  | MAINT | 1006
 |  | 2009-11-05 00:00:00 | BANK | 1001 | D | WDRL PETTY CASH |  | 100 | -100 |  |  | PRINTING | 1007
 |  | 2009-11-06 00:00:00 | BANK | 1001 | D | PETTY CASH FROM BANK |  | 100 | -100 |  |  | STATIONERY | 1008
 |  | 2009-11-07 00:00:00 | BANK | 1001 | D | CASH PAID |  | 85 | -85
 |  | 2009-11-08 00:00:00 | BANK | 1001 | D | [NAME] |  | 20 | -20
 |  | 2009-11-09 00:00:00 | PETROL | 1005 | D | PETROL |  | 15 | -15
 |  | 2009-11-10 00:00:00 | PRINTING | 1007 | C | PRINTING |  | 25 | -25
 |  | 2009-11-11 00:00:00 | MAINT | 1006 | C | MAINT OFFICE |  | 25 | -25
 |  | 2009-11-12 00:00:00 | BANK | 1001 | C | CHQ # 405 |  | 500 | -500
 |  | 2009-11-13 00:00:00 | SALARIES | 1004 | C | [NAME] |  | 250 | -250
 |  | 2009-11-01 00:00:00 | BANK | 1001 | C | CASH RECEIVED FROM DEVID |  | 500 | -500
 |  | 2009-11-02 00:00:00 | LOAN | 1003 | D | PAID TO BANK FOR EXP |  | 500 | -500
 |  | 2009-11-03 00:00:00 | BANK | 1001 | D | PAID TO MICHLE |  | 50 | -50
 |  | 2009-11-04 00:00:00 | SALARIES | 1004 | D | SAL JAN-09 MICHLE |  | 50 | -50
 |  | 2009-11-05 00:00:00 | SALARIES | 1004 | D | WDRL PETTY CASH |  | 100 | -100
 |  | 2009-11-06 00:00:00 | SALARIES | 1004 | C | PETTY CASH FROM BANK |  | 100 | -100
 |  | 2009-11-07 00:00:00 | SALARIES | 1004 | C | CASH PAID |  | 85 | -85
 |  | 2009-11-08 00:00:00 | SALARIES | 1004 | C | [NAME] |  | 20 | -20
 |  | 2009-11-09 00:00:00 | PETROL | 1005 | C | PETROL |  | 15 | -15
 |  | 2009-11-10 00:00:00 | PRINTING | 1007 | D | PRINTING |  | 25 | -25
 |  | 2009-11-11 00:00:00 | MAINT | 1006 | D | MAINT OFFICE |  | 25 | -25
 |  | 2009-11-12 00:00:00 | BANK | 1001 | D | CHQ # 405 | 500 |  | 500
 |  | 2009-11-13 00:00:00 | SALARIES | 1004 | D | [NAME] | 250 |  | 250
 |  | 2009-11-01 00:00:00 | BANK | 1001 | C | CASH RECEIVED FROM DEVID | 500 |  | 500
 |  | 2009-11-02 00:00:00 | LOAN | 1003 | C | PAID TO BANK FOR EXP | 500 |  | 500
 |  | 2009-11-03 00:00:00 | BANK | 1001 | C | PAID TO MICHLE | 50 |  | 50
 |  | 2009-11-04 00:00:00 | SALARIES | 1004 | C | SAL JAN-09 MICHLE | 50 |  | 50
 |  | 2009-11-05 00:00:00 | BANK | 1001 | D | WDRL PETTY CASH | 100 |  | 100
 |  | 2009-11-06 00:00:00 | BANK | 1001 | D | PETTY CASH FROM BANK | 100 |  | 100
 |  | 2009-11-07 00:00:00 | BANK | 1001 | D | CASH PAID | 85 |  | 85
 |  | 2009-11-08 00:00:00 | BANK | 1001 | D | [NAME] | 20 |  | 20
 |  | 2009-11-09 00:00:00 | BANK | 1001 | C | PETROL | 15 |  | 15
 |  | 2009-11-10 00:00:00 | PRINTING | 1007 | C | PRINTING | 25 |  | 25
 |  | 2009-11-11 00:00:00 | MAINT | 1006 | C | MAINT OFFICE | 25 |  | 25
 |  | 2009-11-12 00:00:00 | BANK | 1001 | C | CHQ # 405 |  | 500 | -500
 |  | 2009-11-13 00:00:00 | SALARIES | 1004 | D | [NAME] |  | 250 | -250
 |  | 2009-11-01 00:00:00 | BANK | 1001 | D | CASH RECEIVED FROM DEVID |  | 500 | -500
 |  | 2009-11-02 00:00:00 | LOAN | 1003 | D | PAID TO BANK FOR EXP |  | 500 | -500
 |  | 2009-11-03 00:00:00 | BANK | 1001 | D | PAID TO MICHLE |  | 50 | -50
 |  | 2009-11-04 00:00:00 | SALARIES | 1004 | C | SAL JAN-09 MICHLE |  | 50 | -50
 |  | 2009-11-05 00:00:00 | BANK | 1001 | C | WDRL PETTY CASH |  | 100 | -100
 |  | 2009-11-06 00:00:00 | BANK | 1001 | C | PETTY CASH FROM BANK |  | 100 | -100
 |  | 2009-11-07 00:00:00 | BANK | 1001 | C | CASH PAID |  | 85 | -85
 |  | 2009-11-08 00:00:00 | BANK | 1001 | D | [NAME] |  | 20 | -20
 |  | 2009-11-09 00:00:00 | BANK | 1001 | D | PETROL | 15 |  | 15
 |  | 2009-11-10 00:00:00 | PRINTING | 1007 | D | PRINTING | 25 |  | 25
 |  | 2009-11-11 00:00:00 | MAINT | 1006 | D | MAINT OFFICE | 25 |  | 25
 |  | 2009-11-12 00:00:00 | BANK | 1001 | C | CHQ # 405 | 500 |  | 500
 |  | 2009-11-13 00:00:00 | SALARIES | 1004 | C | [NAME] | 250 |  | 250