The accounting routines of an accounting office involve various activities of manipulation of financial data and equity transactions of companies.
In this context, an accountant needs tools that help him receive and process information from hundreds of businesses a month to perform tasks ranging from payroll, through accounting statements to the issuance of guides of charges and taxes.
Recently, we have been approaching accountants and accounting offices to create excel tools that will help them perform their accounting routines in excel. Last month, we launched the book spreadsheet box in excel and now we've created a new excel accounting tool that I'll demonstrate below.
Accounting Posting Sheet
This was a spreadsheet designed to help accountants and companies communicate and reconcile their accounting entries by automatically generating all the necessary reports.
1. Registration of Account Plan and Accounting Entries
The first and most important configuration of the worksheet is done in its first two tabs. In the chart of accounts, you must register up to 250 accounts following the accounting ID on each of them. In the posting tab, you must define a debit account and other credit for each posting.
2. Monthly Launches
After the initial setup, you will enter the monthly release tabs. In it, each financial transaction must be registered according to its code that will generate the automatic completion of its debit and credit accounts.
3. Balance sheet
Automatically, from the postings, the worksheet will generate the balance of the business demonstrating the movements of each chart of accounts and evaluating if the structure is correct according to its classification (credit / debit)
4. Statement of Cash Flow and Result of Exercise
Just like the balance sheet, the worksheet will automatically generate the two statements of cash flow and the result of exercises of your financial transactions.
5. Balance Sheet
Finally, the spreadsheet will also generate the complete balance sheet of the business already ready for printing and fields for insertion of business data and also counter signature.
Did you like this worksheet? You can try it for free and buy the full version by visiting this link: Accounting Posting Sheet