The balance sheet serves, as a rule, for generalization, competent verification of the correctness of the digital values of the accounting accounts, as well as for creating a new balance sheet. The application of this document in the analysis of the financial and economic process is the first step towards the automation of the analysis, which is based on data from management accounting.
Instructions
Step 1
Create a table of accounts and enter in it all the amounts for the transactions performed. For each account, enter information about the balances for debit and credit processes at the beginning and end of the specified period.
Step 2
Number the first vertical column of the table by account numbers. In the second column, write down the name of each account: fixed assets, goods, investments made in non-current assets, sales expenses, current account, cash desk, settlements with suppliers, settlements with accountable persons and employees on wages, sales and total.
Step 3
Enter the data in the third column of the table for debit and credit for balances at the beginning of the month. That is, divide the third column in two. One part will contain information on credit accounts, and the other on debit.
Step 4
Fill in the 5th and 6th columns of the table. Indicate in them the data of the monthly turnover made on debit and credit. In turn, in the 7th and 8th columns of the table, enter the available data on balances at the end of the month. In this case, also record the information separately for debit and credit transactions.
Step 5
Calculate the turnover and display the balance (balances) at the end of the reporting period. At the same time, check: in the columns "Balances at the beginning of the month" and "Balances at the end of the month" on debit and credit, you should get the same amount.
Step 6
After completing the balance sheet, calculate the totals for each column. Look, a competently and correctly compiled, as well as calculated balance sheet should have a pairwise equality of the column totals. Thus, the following values should be obtained: the amount of the loan in the "Monthly turnover" for sales the amount of the "Balance at the end of the month" for the loan in the same column for sales. Also, in the column "Monthly turnover" in the column "Investments in non-current assets", the numerical values for credit and debit must also be equal.
