Fill in cell A 1: enterprise name (according to the size of the table, just merge and center).
Fill in the A2 cell: 20 1 1 XX monthly voucher summary table (according to the table size, it can be consolidated and centered).
Fill in cells A3 and A4: Voucher number (intermediate consolidation)
Fill in cells B3 and C3: Bank deposit (consolidation center)
Fill in B4 and C4 cells respectively: debit and credit.
Fill in A5 cell: Total
Fill in cell A6 \ A7 \ A8 \ A9 \ a10 \ a11... and fill in 123456 ... (representing voucher number) respectively, which can be extended indefinitely as needed.
Fill in cells D3 and D4: Voucher number (merged in the middle)
Fill in cash on hand in E3 and F3 cells (consolidation center)
Fill in E4 and F4 cells respectively: debit and credit.
Fill in D5 cell: Total or not.
In D6 \ D7 \ D8 \ D9 \ D10 \ D11... cells, respectively, fill in 123456 ... (representing the voucher number), which can be extended indefinitely as required.
Other accounting subjects and so on, assets rank first, liabilities and expenses rank last.
Second, the summary table of voucher accounts focuses on the establishment of total formula!
Line 5: Fill in A5 cells in total.
Input in cell B5 = sum (B6: B 130) Total debit of bank deposit.
C5 cell input = total credit of bank deposits (C6: C 130)
D5\D6\D7 Cell Input 1 2 3 ...
E5 cell input = sum (E6: E 130) total cash debit.
F5 cell input = sum (F6: F 130) total cash debit.
Other subjects can be set by analogy, so that each column can enter 125 vouchers, which is completely sufficient for general enterprises. If it is not enough, it can be pulled down enough;
Third, check the setting of voucher subject summary table.
Calculation formula setting: the total debit and credit formula in the total column is the same as other accounts;
Debit formula of total bank cash in line 65438 +0 =B6+E6.
Formula of total bank cash credit =C6+F6
Debit formula of total bank cash in line 2 =B7+E7.
The credit formula of total bank cash is =C7+F7, and so on for other banks.
In line 1, the debit total formula of other accounts is the debit total of all subsequent accounts.
The total credit formula of other accounts is the sum of all subsequent accounts.
The formula for each row of the difference column is set to
Total cash debit of interbank bank+total debit of other accounts-total cash credit of bank-total credit of other accounts.
If the difference has a numerical value, it means which line is entered incorrectly, which means that the voucher is entered incorrectly and needs to be checked and corrected.
If the difference is zero, the input is correct; All the differences are listed as zero, which proves that the voucher summary table is correctly entered.
Three. Setup of general ledger account balance summary table
Open the spreadsheet, double-click "Table 2" in the lower left corner to modify it to "General Ledger Account Balance Summary Table", and then start compiling the general ledger account balance summary table.
Fill in cell A 1: enterprise name (according to the size of the table, just merge and center).
Fill in the summary of XX month general ledger account balance in A2 cell: 20 1 1 (it can be consolidated and centered according to the table size).
Fill in cell A3: tax payment time: 20 1 1, 00,00 to 20 1 1, 00,00 (according to the table size, the middle can be combined), and 14 after the date represents the number of vouchers in this month.
Fill in cell A4: Assets.
And select 5 cells, such as A4B4C4D4E4, as the merging center;
Fill in F4 cell: liabilities and owner's equity.
And select 5 cells, such as F4G4H4I4J4, and set them as the merging center;
Fill in cell A5: account name.
Fill in cell B5\G5: opening balance.
Fill in cell C5\H5: Debit amount.
Fill in cell D5\I5: Credit Amount.
Fill in cell E5\J5: ending balance.
Fill in the account of the asset side in the cell A6A7A8A9 ... .....
Fill in the accounts of liabilities and owners' equity in cells F6F7F8F9 respectively ... ...
Note: In order to facilitate the convergence of balance sheets, if accounts need to be consolidated, a report column needs to be added above related accounts.
At this point, the first step of general ledger account balance summary has been completed.