FREE TEMPLATE
Get your free
Profit & Loss Tracker
A simple monthly profit and loss tracker for Excel and Google Sheets. Try it out first, completely free.
SEND MY FREE TRACKERJoin the list and claim your free template
Instant download · One-time purchase · No subscription
Help / Multi-Year Bookkeeping System
SETUP GUIDE
Thank you for purchasing the Multi-Year Bookkeeping System! This is a complete bookkeeping system, set up the way an accountant keeps books. Work through this guide at your own pace, one step at a time, and keep it handy as a reference as you go.
WATCH FIRST
This video walks through the full template, tab by tab. Watch it once, then use the steps below as your reference while you set up.
WATCH ON YOUTUBEStart here! This is a full bookkeeping system, so follow the steps below in order. Helper notes and smart prompts are built in to guide you as you go.
Not sure where to begin? Watch the video above first, then come back and work through the steps. Have a quick question? Check the template FAQ.
Your template has locked cells that protect the formulas and links between tabs. Keep the protection on so nothing breaks by accident. You only type in the white cells.
Locked cells can’t be selected or changed. Click a white cell to keep going.
Because you own your copy, Sheets shows a warning instead of blocking you. If it pops up, click Cancel.
Your template has three kinds of tabs. White cells are always where you type.
Where you enter your information.
Automatic and protected. Some you just read; on others you pick the month or year to view.
Mostly automatic, with a few white cells where you enter dates, balances or choices.
See how everything flows together in a completed version. The button opens the Google Sheets example. Using Excel? The example file is in your download folder.
Skip the typing. Paste your bank or credit card transactions into the CSV import file and it lines them up for your Transaction Log. Instructions are inside the file.
The file has two import tabs. Use North America for month first dates (MM/DD/YYYY) or International for day first dates (DD/MM/YYYY). If a date shows a warning, try the other tab.
Using Excel? The CSV import file is in your download folder.
Have a question or something not working as expected? The template FAQ has quick answers, plus a troubleshooting section for common fixes.
Jump to a section
Tap a section to jump straight to it. Click any step to collapse or expand it.
Enter your Company Name (or your name if you’re using it for personal budgeting), your Start Year (the year you begin using the template), select the statement name from the drop down, and set your currency by replacing the dollar symbol with your own.
Optional: select the starting month of your fiscal year, or leave it as January if you follow the calendar year.
Add up to 10 accounts where money comes in or goes out, like bank accounts, credit cards or loans, along with their opening balances. These are used later for your account reconciliations.
Create up to 15 main income and 15 main expense categories. These are your high level reporting buckets that show up on your Profit & Loss and dashboards. Keeping the number of main categories limited is intentional. Too many main categories reduces clarity and makes financial analysis harder. These should remain broad and strategic. For example, General & Administrative or Salaries & Payroll.
Under each main category, add the detail. For example, General & Administrative might include Professional Fees, Legal Fees, Accounting Fees and Office Expenses. They all roll up into the main category on your reports.
DuplicatesIf a category or sub-category is highlighted on the Setup tab, it’s a duplicate. Rename or remove it so your reports stay accurate.
Why it works: This structure mirrors how professional accounting systems are designed. It gives you detailed tracking at the transaction level while keeping dashboards and reports clean, readable, and decision focused.
Helper notes are built in throughout the workbook. To hide them for a cleaner view or for printing, tick the checkbox (Google Sheets) or type YES (Excel). Clear it any time to bring them back.
TipOnce you’ve entered transactions, don’t rename your categories or subcategories, since that breaks the links between tabs. If you don’t need a category, simply leave it blank. You can always add new categories as you need them.
The Chart of Accounts tab is automatically generated based on the categories you define in the Setup tab. This tab does not require any manual entry. As you add or update income and expense categories in the Setup tab, they will automatically appear here and remain organized by Main Category and Sub-Category.
Error checkCheck the warning at the top of the tab. If any main category is missing a subcategory, a red warning appears and those transactions won’t show on your dashboards. Clear the warning before you move on.
Enter your budgeted net income (or savings) by month. Your dashboards use it to track your progress.
Every report in the template is built from this tab, so this is where you’ll spend most of your time.
If a date is not entered correctly, a pop-up will appear. Ensure a valid date is entered.
Enter a description for the transaction. This is for your own recordkeeping and can be as brief or detailed as you like. You can also use the description directly from your bank statement.
Enter all amounts as positive values, except for the following cases:
💡 Save timeSteps 1 through 3 can be completed all at once using the CSV import method. See CSV Import at the bottom of this step.
The Transaction Amount should always be the total amount received or paid, including any sales tax. If you enter a sales tax rate, the template automatically extracts the tax and calculates the net amount for you. It works backwards from the total, so it never adds tax on top.
Don’t collect or remit sales tax? Simply leave the Sales Tax Rate column blank and the full amount flows directly into your Profit & Loss.
This is the most important field. Income and Expense transactions impact your Profit & Loss. All other transaction types affect cash/accounts only.
Money coming into your business that impacts your Profit & Loss
Money leaving your business that impacts your Profit & Loss
Moving money between your own accounts, like a credit card payment (see the FAQ)
Cash you put into the business (does not impact Profit & Loss)
Money you take out of the business (does not impact Profit & Loss)
Don’t worry!You don’t need to memorize this. As you enter each transaction, the Smart Prompts column in your Transaction Log will guide you and show a clear message if something needs to be fixed.
The warning counter at the top of the Transaction Log must show zero before your dashboards will be accurate. If you see a warning, the row will tell you exactly what to fix. Just follow the message. Common fixes:
You can save significant time by copying transactions directly from your bank statement CSV download instead of entering them one by one. See the separate “CSV Import File” included in your downloads, which includes detailed instructions.
The file has two import tabs. Use North America for month first dates (MM/DD/YYYY) or International for day first dates (DD/MM/YYYY). If a date shows a warning, try the other tab.
Want it faster? The Auto-Mapping version fills in the Transaction Type, Category and Sub-Category for you.
Your Profit & Loss pulls everything from the Transaction Log, using the categories from your Setup tab. Blue cells calculate on their own. Use it to spot trends, compare months and see how profitable you are.
Both views stay in sync automatically.
Select a month and enter the year to automatically populate the Monthly Dashboard for the selected period. The dashboard provides a high level view of key metrics, including income, expenses, net income, income allocation, expense distribution, and progress toward your savings goal.
Enter the year to automatically populate the Annual Dashboard for the selected year. This dashboard provides similar charts and key metrics as the Monthly Dashboard but presents results by month across the full year, along with full year totals.
Use this dashboard to review annual performance, compare monthly trends, and evaluate overall results for the selected year.
Enter the first year in the 5 year range to automatically populate the 5 Year Dashboard. The following four years will auto populate, displaying totals and visual charts for the full five year period.
This dashboard provides a high level view of long term performance, including revenue, expenses, net income, and key trends over multiple years. Use this view to assess growth, consistency, and overall financial direction.
The Transaction History tab provides a consolidated, read only view of all transactions entered in the Transaction Log. All data flows in automatically.
This drill down functionality mirrors how professional accounting systems allow users to explore general ledger activity. It helps you understand your transactions, investigate variances, and analyze activity at both a high level and a detailed level.
This template includes two ways to review your account balances. Both tabs allow you to monitor all cash activity across your accounts, including bank and credit card statements. All transactions flow automatically from the Transaction Log based on the account selected.
ImportantFor this to function properly, each transaction must include the correct From Account or To Account.
Review each option to decide which is more suitable for you, and hide the other tab. Or feel free to use both!
A flexible way to monitor cash activity across your accounts using custom date ranges. Great for checking balances for any period you choose. It does not perform statement reconciliation.
Custom View
Reconcile your accounts directly to your bank or credit card statements, similar to traditional accounting software. The template determines the statement period and compares the balance from your Transaction Log to the balance on your statement.
Accounts Reconciliation View
First monthThe statement start date defaults to the template start date defined in the Setup tab. For example, if the template begins in January 2026 and your first statement ends on January 25, 2026, transactions will be pulled from January 1 to January 25, 2026. Any activity before the template start date should be reflected in the opening balances entered in the Setup tab.
ImportantOnly one statement date per account per month should be entered. Duplicate months will trigger an error warning, and statement dates should be entered in chronological order.
If you use the sales tax rate column in your Transaction Log, enter a year here to see the sales tax you collected and paid, by period. Use it to support your sales tax filings.
At the end of each month, once all your transactions are in, enter the closing balances for your bank accounts, credit cards, loans, sales tax payable and other assets and liabilities. The account names are a starting point, so rename them to fit your business.
Since this is a multi-year template, the Balance Sheet doesn’t roll forward on its own.
That’s it. Close your month with confidence and be ready for year end.
Disclaimer: This template is provided for small business budgeting and reporting purposes only and does not constitute professional financial, accounting, or tax advice. Always review your numbers carefully and consult a qualified professional before making financial or tax decisions.
© 2026 InsightSheets. For personal and business use only. Not for resale or redistribution.
Most questions are answered in the FAQ. Still stuck? Send me a message and I’ll help you get set up.
WANT IT FASTER?
The Auto-Mapping version sorts your bank transactions into categories for you, with up to 1,000 keyword rules.