A monthly trial balance report can be downloaded to Excel. More or less accounts may be downloaded in subsequent months. So you can have a workbook with several worksheets of different sizes (number of rows) representing each month. The first column (field) contains both an account and account description. The 5th column has the amount.
Is there a way to create one summary worksheet with all the accounts from the other monthly worksheets in column A, in account order, followed by columns of monthly Year to Date balances ? The account and description are in column A and the balance in column E.
Co.. X.. January
--------A---------B-----C------D-------E
12345..cash…..3.15..3.15…...6.30….57.66
15211..parts…..1.20..4.20..<3.00>.19.23
Co.. X.. February
--------A---------B-----C------D-------E
12345..cash…..1.15..3.15..<2.00>.…55.66
15211..parts…..0.00..0.00…0.00…....19.23
18833..receiv…5.00...3.00…2.00....105.45
Co.. X.. March
--------A---------B-----C------D-------E
10001..cash…..1.00..0.00…1.00.…..1.00
15211..parts…..0.00..0.00…0.00….19.23
18833..receiv…3.00..3.00…0.00....105.45
19999 scrap…15.00 1.00 14.00…404.06
Goal
Quarter..1……Jan…..…...Feb……...Mar….
10001..cash……0.00……0.00…..….1.00……
12345..cash…..57.66 .....56.66….......0.00
15211..parts…..19.23…..19.23….....19.23
18833..receiv….0.00….105.45……105.45
19999 scrap… 0.00…… 0.00…….404.06
Is there a way to create one summary worksheet with all the accounts from the other monthly worksheets in column A, in account order, followed by columns of monthly Year to Date balances ? The account and description are in column A and the balance in column E.
Co.. X.. January
--------A---------B-----C------D-------E
12345..cash…..3.15..3.15…...6.30….57.66
15211..parts…..1.20..4.20..<3.00>.19.23
Co.. X.. February
--------A---------B-----C------D-------E
12345..cash…..1.15..3.15..<2.00>.…55.66
15211..parts…..0.00..0.00…0.00…....19.23
18833..receiv…5.00...3.00…2.00....105.45
Co.. X.. March
--------A---------B-----C------D-------E
10001..cash…..1.00..0.00…1.00.…..1.00
15211..parts…..0.00..0.00…0.00….19.23
18833..receiv…3.00..3.00…0.00....105.45
19999 scrap…15.00 1.00 14.00…404.06
Goal
Quarter..1……Jan…..…...Feb……...Mar….
10001..cash……0.00……0.00…..….1.00……
12345..cash…..57.66 .....56.66….......0.00
15211..parts…..19.23…..19.23….....19.23
18833..receiv….0.00….105.45……105.45
19999 scrap… 0.00…… 0.00…….404.06