
Annual Report
Docs + Word6 pages
FeaturedFree
A journal is where every transaction first lands, one entry at a time. In this log each entry can have two or more lines that share an entry number. The Entry check column adds the debits and credits for that number and turns the row red when they differ by even a cent. The sample holds eight October entries for a small print shop: rent, an invoice, a restock, a customer payment, payroll, a used machine bought partly on credit, a utility bill and cost of goods sold.
Ledger Totals sums the debits and the credits of 13 accounts and charts them, which makes it a ready source for a trial balance. Account names come from a dropdown, so spelling stays consistent and the totals pick up every line. If your accounts differ, edit the dropdown and the totals table together.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Entries tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
It is a record of one transaction that touches at least two accounts, with debits and credits that add up to the same amount.
Use one row for each account and give all of them the same entry number. The check adds the lines together, so a three-line entry balances as a whole.
Yes. Edit the list in the Account column's data validation and give the new account a row in the Ledger Totals table so its lines are counted.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free