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-Business Bookkeeping System
SETUP GUIDE
Thank you for purchasing the Multi-Business Bookkeeping System! This is a complete multi-year bookkeeping system for tracking two or more businesses in one workbook, with consolidated reporting, a view for each business, and the option to split shared transactions across businesses. 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 YOUTUBEHeads up: the template has been updated since this video was recorded, so a few screens may look slightly different. Newer features, like Pay or receive later and the Unpaid Summary tab, aren’t shown in the video but are covered in the steps below.
Start 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? Work through the steps below in order. 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 business, 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, with sample transactions across four businesses, including shared transactions split between them. 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.
Your template comes with seven Transaction Types. They can’t be edited, and are shown on the Setup tab so you can see what each one is for. Each type is explained in detail in the Transaction Log section below.
Add up to 10 businesses. These can be legal entities, subsidiaries, business units, or any part of your business you’d like to track separately. Leave any unused rows blank.
Add up to 10 accounts where money comes in or goes out, like bank accounts, credit cards, PayPal or loans, along with their opening balances. These are used later for your account reconciliations.
Create up to 15 income and 15 expense main 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. Names must be unique.
Money your businesses earn. Keep these broad, for example Service Revenue, Product Sales or Rental Revenue.
Money your businesses spend to operate. Keep these broad and strategic, for example Cost of Goods Sold, Payroll & Contractors or Office & Admin.
Under each income and expense main category, add the detail. First, select the main category from the drop down menu, which automatically lists the main categories you set up in Step 5. Then type the sub-category next to it. For example, Office & Admin might include Office Supplies, Printing, Postage and Bank Fees. They all roll up into their 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, check the box (Google Sheets) or type YES (Excel). Clear it any time to bring them back.
Once you’ve entered transactions, don’t rename anything you’ve set up: your businesses, accounts, categories and sub-categories. Your transactions are linked by name, so renaming breaks the links between tabs.
Don’t need one? Simply leave it as is or leave the cell blank. You can always add new ones as you need them.
The Chart of Accounts tab is automatically generated based on the categories you define in the Setup tab. As you add or update income and expense categories in the Setup tab, they will automatically appear here, organized by Main Category and Sub-Category.
Error checkCheck the warning at the top of the tab. If any main category is missing a sub-category, 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 by month. Your dashboards use it to track your progress. This is a consolidated budget, so it should reflect your target for all your businesses combined.
Every report in the template is built from this tab, so this is where you’ll spend most of your time. Date, Amount and Transaction Type are always required. The Transaction Type you pick decides what else is needed, and the Smart Prompt column tells you exactly what’s missing.
Enter the date of the sale, the date the bill was dated or paid, or the date the purchase was made. This is the transaction date. It’s often the same date the money shows on your bank or credit card statement, but it doesn’t have to be. If the money is paid or received on a different date, use the Pay or receive later feature.
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:
Sales tax: enter the total amount received or paid, including any sales tax. If you enter a Sales Tax Rate, the template works backwards from the total to pull out the tax and calculate the net amount for you. It does not add tax on top.
💡 Save timeSteps 1 through 3 can be completed all at once using the CSV import method. It’s a great way to bring in your bank and credit card transactions and get started quickly. You can still add transactions that aren’t on your statements, like unpaid bills or invoices, as part of your month end close. See CSV Import at the bottom of this step.
This is the most important field. The following are the transaction types, and they decide which columns you need to fill in.
Shows on your Profit & LossMoves cash between, into or out of your accounts only✓Required–Not applicable, leave blank
| Transaction Type | Business1 | Category & Sub-Category | To Account | From Account | Unpaid2 |
|---|---|---|---|---|---|
| Income: Money your business earns from sales or services, such as services provided, product sales, rental income or interest | ✓ | ✓ | ✓ | – | Optional |
| Expense: Money your business spends to operate, such as rent, inventory, wages, software, advertising and bank fees | ✓ | ✓ | – | ✓ | Optional |
| Transfer3: Money moved between your own accounts, such as chequing to savings or paying off the credit card | – | – | ✓ | ✓ | – |
| Owner's Contribution: Money you put into the business from your personal funds, such as startup cash or covering a shortfall | Optional | – | ✓ | – | – |
| Owner's Withdrawal: Money you take out of the business for personal use, such as an owner draw | Optional | – | – | ✓ | – |
| Other Deposit: Money received that is not income, such as a loan received or a petty cash deposit | Optional | – | ✓ | – | – |
| Other Withdrawal: Money paid out that is not an expense, such as a loan principal payment or a security deposit | Optional | – | – | ✓ | – |
Don’t worry!You don’t need to memorize this. As you enter each transaction, the Smart Prompt column in your Transaction Log will guide you and show a clear message if something needs to be fixed.
Mark the transaction as Unpaid if the money is paid or received after the transaction date (check the box in Google Sheets, or select Yes in Excel), then enter the Paid or Received Date once it happens. This applies to Income and Expense only. See Pay or receive later below for how it works, with examples.
Add anything you’d like to remember, such as an invoice number, a cheque number or who approved the payment.
If you selected Multiple as the Business, scroll to the right side of the row and enter the percentage for each business. The split must add up to 100%. See Split across businesses for an example.
The counter at the top of the Transaction Log must show “No errors flagged” before your dashboards will be accurate. If you see a warning, the row will tell you exactly what to fix. Just follow the message.
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.
Some costs and income are shared, like one software subscription used by every business, or rent for an office two businesses share. Instead of entering the transaction more than once, enter it once and split it.
Must equal 100%If a split doesn’t add up to 100%, the row shows a warning and the counter above the split columns shows how many need fixing. Fix these before you review your business views, or a business’s numbers will be off.
Consolidated is always completeYour Consolidated view always includes every transaction in full, whether or not it has a business or a split.
Sometimes the money moves on a different day than the transaction. A bill arrives in March but is paid in April. You buy supplies with your personal card and the business repays you later. A client is invoiced in June but pays in July. The Unpaid? checkbox handles all of these, so your reports and your bank balances are both right.
An Expense you owe but haven’t paid yet, such as a utility bill or a supplier invoice. In accounting, this is an accrued expense or accounts payable.
An Expense paid personally by you or an employee that the business will repay. Record it as an Expense on the purchase date and mark it Unpaid until it’s repaid.
Income you’ve earned but haven’t received yet, such as an invoice sent to a client. In accounting, this is accrued income or accounts receivable.
Only for Income and ExpenseUnpaid only applies to Income and Expense. Leave it blank for Transfers, Owner’s Contributions and Withdrawals, Other Deposits and Other Withdrawals.
Google Sheets or ExcelIn Google Sheets, Unpaid is a checkbox. In Excel, select Yes from the drop down.
See everything in one place: every transaction marked Unpaid also shows on the Unpaid Summary tab, so you can see what’s still outstanding at a glance. See Unpaid Summary below.
Your Profit & Loss and dashboards use the transaction date. The income or expense shows in the month it was earned or incurred, whether or not it’s been paid.
Your account tabs use the Paid or Received Date, so your balances only change when the money actually moves, matching your bank statement. Until a date is entered, the transaction stays out of your account balances.
Note: If a transaction isn’t marked Unpaid, your account tabs use the transaction date instead.
Select a business, or Consolidated for all businesses combined, and enter the year. Your Profit & Loss fills in from the Transaction Log, using the categories from your Setup tab. The title uses the statement name you picked in Setup. Blue cells calculate on their own.
Both views stay in sync automatically. Amounts are shown before sales tax.
On every dashboard, select a business from the drop down, or Consolidated to see all your businesses combined.
Select the business and 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 total income, total expenses, net income, net profit margin, expenses as a percentage of income, income and expenses by category, and progress toward your budget.
Select the business and enter the year to automatically populate the Annual Dashboard. 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.
Select the business and enter the most recent year you’d like to see. The four years before it populate automatically, displaying totals and visual charts for the full five year period.
This dashboard provides a high level view of long term performance, including income, expenses, net income and key trends over multiple years. Use this view to compare businesses, assess growth and consistency, and see your 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.
Every transaction marked Unpaid in your Transaction Log flows here automatically. Use the filter to choose what you see:
Each row shows the date, transaction type, description, amount, category, sub-category, business and paid or received date. The total at the top shows Income and Expense separately for the filter you selected.
Owed by you or to you?Expense transactions are amounts you owe, like bills and reimbursements. Income transactions are money owed to you, like an invoice a client hasn’t paid yet. With the filter set to Unpaid, the totals at the top give you your Expense total (accounts payable) and your Income total (accounts receivable), ready to enter on the right lines of your Balance Sheet.
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. Transactions are always pulled in on their transaction date, unless they are marked Unpaid. Unpaid transactions are pulled in on their Paid or Received Date instead, once it’s entered.
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 the year to see a monthly summary for all your businesses combined.
Check with your accountantUse this tab to support your sales tax filings. Sales tax rules vary by location, so confirm your obligations with a qualified professional.
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 Balance Sheet is consolidated, for all your businesses combined. The account names are a starting point, so rename them to fit your businesses.
Using Unpaid?At the end of each month, go to your Unpaid Summary tab and filter for Unpaid. The total at the top shows your accounts receivable (Income, money owed to you) and accounts payable (Expense, amounts you owe). Enter these totals on your Balance Sheet.
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 bookkeeping 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.