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
MULTI-YEAR BOOKKEEPING SYSTEM
Find answers to common questions about using your Multi-Year Bookkeeping System, including the Auto-Mapping version.
Categories, credit cards, sales tax, paying yourself, accruals, the Balance Sheet and sharing your reports.
Most askedWhen you record a transaction in the Transaction Log, you assign it a main category and a sub-category. The main category is the high level grouping, and the sub-category captures the specific detail underneath it. Every transaction flows into both levels automatically, so nothing is ever lost. It simply rolls up into the broader category on high level reports.
Here’s how the roll up shows up throughout the template:
This layered approach lets you understand performance at a high level, while always being able to drill into the full detail when you need it.
Yes. Enter your name instead of a company name on the Inputs tab and customize the categories for personal use.
No problem. Set up Cost of Goods Sold as its own main expense category in Section 1.3 of the Inputs tab. Under it, create sub-categories for the direct costs of producing your goods or services.
For clarity, you can name the sub-categories with a COGS prefix, for example:
COGS: Raw MaterialsCOGS: FreightCOGS: Packaging
This keeps your Cost of Goods Sold clearly separate from your operating expenses in your reports.
The template is intentionally designed with up to 15 main categories and 75 sub-categories (for both income and expenses) to keep your financial reporting clear, structured and easy to analyze as your business grows. For most small businesses, this is more than enough detail and avoids overcomplicating your dashboards and financial statements.
If you need more categories, send me a message and we can talk about a custom version.
On the account reconciliation tabs, your bank account shows an outflow and your credit card shows an inflow, reducing the outstanding balance.
You can also use Transfer to move money between bank accounts, like from Chequing to Savings.
Always enter the total amount you received or paid in the Transaction Log, including any sales tax. Then enter the sales tax rate for that transaction. The template works backwards from the total to split out the tax and the net amount for you. It never adds tax on top.
Don’t collect or pay sales tax? Leave the rate blank and the full amount flows to your Profit & Loss.
It depends on how your business is set up:
Putting money into the business works the same way in reverse. Record it as Owner’s Contribution / Other Deposit.
Not sure which applies to you? Check with your accountant.
Watch the full accruals tutorial on YouTube
Yes. The template is built for cash basis (you record income and expenses when the cash moves), which keeps your bank reconciliation simple and works well for most small businesses. But you can easily convert it to accrual basis using the accounts section.
With accrual basis, you record income when it’s earned and expenses when they’re incurred, even if the cash hasn’t moved yet. For example, you finish a project in August but your client pays in September, or your August water bill doesn’t arrive until September. Accruals match your income and expenses to the month they actually belong to.
How to record accruals in 4 steps:
Built-in check: use the Accounts Reconciliation tab on your accrued accounts. At month end, the balance should equal your accruals. Once the cash comes in and you’ve reversed, it should be zero. If it shows unreconciled, you probably forgot a reversal.
The template includes a manual monthly Balance Sheet. At the end of each month, once all your transactions are recorded and your books are complete, enter your closing balances for accounts like bank accounts, credit cards, loans, sales tax payable and accrued liabilities.
Since this is a multi-year template, once you finish a fiscal year, save or export a copy of the Balance Sheet tab for your records, then clear the balances to begin the next year.
Hide the helper notes first (on the Inputs tab) for a clean view, then:
Your accountant will usually want your Summary or Detailed Profit & Loss, your Balance Sheet and your account reconciliations.
Starting partway through the year and what to do when your year wraps up.
Start hereImportant: your start month on the Inputs tab should always match the first month of your fiscal year, not the month you start using the template.
For example, if your fiscal year runs January to December and you start using the template in May, your start month should still be January.
This keeps your full year Profit & Loss, dashboards and year over year comparisons complete and accurate.
Since this is a multi-year template, you keep using the same file. There’s no need to start a new one. At year end:
Then keep entering transactions as normal. Your dashboards and 5 Year Dashboard will show the new year alongside your past years.
Questions about the Mapping Setup tab and keyword rules.
Auto-Mapping onlyNo, it’s completely optional. If you prefer to enter transactions manually or don’t import from a bank CSV, you can skip and hide the Mapping Setup tab. Just select your Transaction Type, Category and Sub-Category in the Override columns of the Transaction Log.
Use the Override columns in the Transaction Log to fix that specific row. Your override always takes priority over the auto-mapped result.
If it keeps happening, your keyword is probably too broad. Keyword matches are partial, so “ESSO” would also match “MONTESSORI”. Make the keyword more specific on the Mapping Setup tab.
Bank descriptions aren’t always consistent. For example, you might see “WALMART” one month and “WAL-MART” the next. Simply add two separate keyword rules pointing to the same category, and both will map correctly. Keywords aren’t case sensitive, and you can add up to 1,000 rules.
Keyword rules fill in the Transaction Type, Category and Sub-Category only. The From and To Accounts don’t auto-populate from the Mapping Setup tab, so select them manually for each transaction.
Editing protected cells and keeping a clean copy of your template.
Good to knowIn Excel
Go to Review, then select Unprotect Sheet. This removes protection from that tab only, so you can make edits like changing colours, formatting or layout. When you’re done, go back to Review and select Protect Sheet to turn it back on.
Note: Please be careful when editing, since deleting or changing formulas can affect how the workbook works. Protection is set for each tab, so unprotecting one tab won’t affect the others.
In Google Sheets
You can temporarily bypass protection. When you try to edit a protected cell, a Heads up warning appears. Tick Don’t show this again for 5 minutes and click OK. You can then edit protected cells for 5 minutes, and protection resumes automatically afterward.
Removing protection permanently (not recommended):
Note: This removes protection completely. It won’t come back on its own and would need to be set up again manually.
Protected cells prevent accidental changes to formulas. If you see a protection message, click Cancel and only enter data in the input cells.
If formulas are accidentally changed and the workbook stops working as expected, it’s best to start with a fresh copy.
Since this is a multi-year template, you can keep using the same file year after year. You only need a new copy if you want a completely fresh start or you’re setting up a different business.
Quick fixes if something isn’t opening or adding up.
Quick fixesMost of the time, it’s because the folder hasn’t been unzipped yet. Files opened from inside a ZIP folder may not open or save properly.
Always work in your own copy. Please don’t request edit access to the original link.
Yes. The Excel version works on both Mac and PC, and Google Sheets works on any device with a web browser. The template isn’t compatible with Apple Numbers, since it doesn’t support all of the formulas.
Still need help?
If you can’t find the answer you’re looking for, feel free to reach out.
CONTACT ME