Multi Business Bookkeeping: Setup Guide

Help  /  Multi-Business Bookkeeping System

SETUP GUIDE

Multi-Business Bookkeeping System

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.

Step-by-step guide Excel and Google Sheets Up to 10 businesses

WATCH FIRST

Prefer to watch? Start here.

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 YOUTUBE

Heads 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.

Before you start

First time using the template?

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.

Protected cells

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.

EXCEL

Locked cells can’t be selected or changed. Click a white cell to keep going.

  • Turn protection offReview → Unprotect Sheet
  • Turn it back onReview → Protect Sheet → OK
  • Excel for the webReview → Manage Protection, then switch it off or on
GOOGLE SHEETS

Because you own your copy, Sheets shows a warning instead of blocking you. If it pops up, click Cancel.

  • Turn protection offData → Protect sheets and ranges → click the sheet → trash icon
  • Turn it back onData → Protect sheets and ranges → Add a sheet or range
  • Each tab is separateProtection is set tab by tab, so only remove it where you need to
Before you unprotect: save a copy of your file first, only change what you need, then turn protection back on. Formula cells can’t be undone once they’re overwritten and saved.

Legend

Your template has three kinds of tabs. White cells are always where you type.

INPUT TABS

Where you enter your information.

  • SetupYour details, businesses, accounts and categories. Do this first.
  • BudgetYour monthly net income targets, year by year.
  • Transaction LogWhere you’ll spend most of your time. One row per transaction.
  • Balance SheetUpdated at month end: enter your balance sheet account names and amounts.
REVIEW TABS

Automatic and protected. Some you just read; on others you pick the business, month or year to view.

  • Chart of AccountsYour categories at a glance, built from the Setup tab. Nothing to select.
  • Profit & LossPick the business and year to see monthly income, expenses and net income.
  • DashboardsPick the business, month and year for the Monthly, Annual and 5 Year views.
  • Unpaid SummaryFilter to see your unpaid and paid transactions.
  • Sales Tax ReportingEnter the year to see sales tax collected and paid by month.
HYBRID TABS

Mostly automatic, with a few white cells where you enter dates, balances or choices.

  • Accounts ReconciliationEnter your statement dates and balances to confirm each account matches.
  • Accounts CustomChoose any date range to check your account balances.
  • Transaction HistorySelect a category to see its transactions.

See a fully populated example

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.

Bank CSV import file

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.

Template FAQ

Have a question or something not working as expected? The template FAQ has quick answers, plus a troubleshooting section for common fixes.

Let’s get started

Jump to a section

Tap a section to jump straight to it. Click any step to collapse or expand it.

Setup tab Your details, businesses, accounts and categories.

Step 1⚙️ Your details

  • Consolidated Business Name – the name for all your businesses combined, for example your holding company or family name. It shows on your consolidated reports.
  • Start Year – the year you begin using the template
  • Statement Name – select one from the drop down, for example Profit & Loss Statement or Income Statement
  • Currency – replace the dollar symbol with your own
  • Optional: Fiscal Start Month – select the starting month of your fiscal year, or leave it as January if you follow the calendar year. The template confirms your first fiscal year right below, so you know which year to select throughout the workbook. Don’t log transactions before your start date.

Step 2🏷️ Understand your Transaction Types

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.

Step 3🏢 Set up your businesses

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.

  • Throughout the template you can view Consolidated reporting, which combines all your businesses, or review each business on its own.
  • You can add more businesses later, but don’t delete or rename a business once you’ve entered transactions for it.

Step 4🏦 Set up your accounts

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.

  • Your opening balance should reflect the balance at the time you first begin using your template. For example, if you selected January as your starting month and 2025 as your start year in Step 1, enter the opening balances as of January 1, 2025.
  • Bank accounts: enter as positive amounts.
  • Credit cards and loans: enter as negative amounts.

Step 5📁 Set up your main categories

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.

Income

Money your businesses earn. Keep these broad, for example Service Revenue, Product Sales or Rental Revenue.

Expense

Money your businesses spend to operate. Keep these broad and strategic, for example Cost of Goods Sold, Payroll & Contractors or Office & Admin.

Step 6📂 Add your sub-categories

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.

  • Up to 75 income and 75 expense sub-categories
  • To maintain performance and ensure the template runs smoothly, each main category is limited to 25 sub-categories.
  • Your categories won’t appear in the Transaction Log until this step is complete.

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.

Optional👀 Hide notes

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.

Golden rule for your Setup tab

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.

Chart of Accounts A clean view of how your categories roll up.
No manual input required

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.

Budget Set your net income goal for each month.

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.

  • Budget up to 10 years, starting with the Start Year on your Setup tab
  • No need to fill in every year now. Add each year’s budget when it begins.
  • Enter a positive number for a planned profit and a negative number for a planned loss
  • Totals calculate on their own and flow into your dashboards
Transaction Log This is where you record every transaction. Do this daily or weekly as you go.

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.

Step 1🗓️ Input date of transaction

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.

Step 2✏️ Enter the Description

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.

Step 3💰 Enter the amount and optional sales tax

Enter all amounts as positive values, except for the following cases:

  • Returns and Discounts → negative values
  • Expense Recoveries (e.g., an insurance reimbursement or supplier refund) → negative values

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.

  • For example, if you received $113 and the tax rate is 13%, enter $113 as the amount and 13% as the rate. The template calculates $13 of tax and $100 net.
  • Enter the rate as a percentage, such as 13%, not 13.
  • Don’t collect or pay sales tax? Leave the Sales Tax Rate blank and the full amount flows into your Profit & Loss.

💡 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.

Step 4🏢 Select the Business

  • Select the business the transaction belongs to. The drop down lists the businesses from Step 3 of the Setup tab.
  • If it’s shared by more than one business, select Multiple and split it by percentage (see Split across businesses).
  • Required for Income and Expense. Optional for all other Transaction Types. If left blank, the transaction only appears in your Consolidated view and won’t show in any individual business view.

Step 5🏷️ Pick your Transaction Type

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 TypeBusiness1Category & Sub-CategoryTo AccountFrom AccountUnpaid2
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 shortfallOptional–✓––
Owner's Withdrawal: Money you take out of the business for personal use, such as an owner drawOptional––✓–
Other Deposit: Money received that is not income, such as a loan received or a petty cash depositOptional–✓––
Other Withdrawal: Money paid out that is not an expense, such as a loan principal payment or a security depositOptional––✓–
  1. 1Business: select a business, or Multiple to split it (see Split across businesses). Optional for cash types, but select one if you want the transaction to show in that business’s view.
  2. 2Unpaid: mark it Unpaid if the money is paid or received after the transaction date, and leave the account blank until it moves (see Pay or receive later).
  3. 3Transfers: see the FAQ for how to record credit card payments.

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.

Step 6📂 Select your Category and Sub-Category

  • The drop down shows only the categories that match your Transaction Type: income categories for Income and expense categories for Expense.
  • Required for all Income and Expense transactions. These selections drive your dashboards and Profit & Loss.
  • Not required for transfers, owner transactions, deposits or withdrawals.

Step 7⏳ Pay or receive later

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.

Step 8🏦 Select your Accounts

  • Select the To and/or From Account based on the Transaction Type. These drive your Accounts Reconciliation and Accounts Custom tabs.
  • For an unpaid transaction, leave the account blank until it’s paid or received.

Optional📝 Notes

Add anything you’d like to remember, such as an invoice number, a cheque number or who approved the payment.

Step 9➗ Split shared transactions

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.

Step 10⚠️ Check your warning counters before reviewing dashboards

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.

  • Warning: something needs to be fixed, such as a missing Transaction Type, the wrong Category for the Transaction Type, a missing account, or a Transfer with the same From and To Account.
  • Reminder: not an error. It means a transaction is still unpaid. The counter shows how many, for example “Reminder: 2 transaction(s) unpaid.”
  • Allocation counter: there’s a second counter above the split columns on the right. It must also be clear before you review your business views.

💡 CSV Import: Copy and Paste from your Bank Statement

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.

  1. Download your bank statement as a CSV from your online banking portal, and open the CSV and arrange your columns to match the Transaction Log order: Date, Description and Amount.
  2. Use Paste Special (not regular paste) to paste values only. This preserves the existing formatting and formulas in the template. You can paste directly into the Transaction Log, or use the CSV Import File for assistance.
  3. Once pasted, go through each row and select the Business, Transaction Type, Category, Sub-Category and Accounts from the dropdowns.
Split across businesses Share one transaction between businesses with the allocation feature.

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.

How to split a transaction

  1. Enter the transaction as usual, with the full amount.
  2. Select Multiple as the Business.
  3. Scroll to the right side of the row. Each of your businesses has its own column. Enter the percentage for each business that shares it.
  4. Make sure the percentages add up to 100%. Leave the other businesses blank.
Example
  • A $1,200 accounting software subscription is used by three businesses.
  • Based on your own allocation method, for example by usage, revenue or headcount, you decide Business A gets 50% and Businesses B and C get 25% each. Select Multiple and enter those percentages.
  • Result: each business view shows its share ($600, $300 and $300), and your Consolidated view shows the full $1,200.

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.

Pay or receive later How the Unpaid checkbox works for bills, reimbursements and invoices.

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.

When to mark it Unpaid

Bills paid later

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.

Reimbursements

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.

Invoices not yet paid

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.

How to enter it

  1. On the transaction date: enter the Expense or Income as usual, with the Business, Category and Sub-Category. Mark it Unpaid and leave the From Account (Expense) or To Account (Income) blank.
  2. While it’s unpaid: the Smart Prompt shows a Reminder, for example “Pending. Once paid, enter the Paid or Received Date and the From Account.” This is not an error, and the counter at the top shows how many transactions are still unpaid.
  3. Once it’s paid or received: go back to the same row and enter the Paid or Received Date and the account. Keep it marked as Unpaid. The reminder clears on its own.

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.

How it shows in your reports

Transaction Date

Profit & Loss and dashboards

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.

Paid or Received Date

Accounts Reconciliation and Custom

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.

Example
  • March 3: your bookkeeper sends an $850 invoice for March. Enter an Expense dated March 3 under Professional Fees: Bookkeeping Fees, select the Business, mark it Unpaid, and leave From Account blank.
  • April 20: you pay the invoice by e-transfer. On the same row, enter April 20 as the Paid or Received Date and your chequing account as the From Account.
  • Result: the $850 shows as a March expense on your Profit & Loss, and your chequing account drops by $850 in April. At the end of March, it shows as unpaid on your Unpaid Summary.
Profit & Loss Your net income by month, for each business or all combined.
No manual input required (other than the business and year)

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.

  • Summary view: main categories only, for a clean, high level view
  • Detailed view: every sub-category under its main category, listed alphabetically, so you can see exactly what makes up each category line
  • Net Income: your income less your expenses for each month and the year
  • Net Cash Flows: Owner’s Contributions and Withdrawals, Other Deposits and Other Withdrawals are shown last, so you can see your net income after cash movements
  • Business views: include transactions tagged to that business plus its share of any split transactions

Both views stay in sync automatically. Amounts are shown before sales tax.

Monthly, Annual and 5 Year Dashboards Select a business, month or year and your charts fill in.

On every dashboard, select a business from the drop down, or Consolidated to see all your businesses combined.

Monthly Dashboard

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.

  • Automatic prior year comparison: prior year results populate automatically, so you can quickly review variances and identify seasonal trends.
  • 15 month trailing chart: when a month is selected, income, expenses and net income for the prior 15 months are displayed to help visualize performance trends over time.
    • For example, selecting May 2026 populates May 2025 comparatives and displays a trailing period from March 2025 through May 2026.

Annual Dashboard

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.

5 Year Dashboard

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.

Transaction History Drill into the transactions behind any category.
No manual input required (other than category selection)

The Transaction History tab provides a consolidated, read only view of all transactions entered in the Transaction Log. All data flows in automatically.

  • Two sides: income history on the left, expense history on the right, with the business shown on every row
  • Filter by main category to view all related activity
    • To drill down further, select a sub-category to narrow your results
    • Optional: filter by calendar year by entering the year directly

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.

Unpaid Summary Everything you’ve marked as Unpaid, in one list.
No manual input required (other than the filter)

Every transaction marked Unpaid in your Transaction Log flows here automatically. Use the filter to choose what you see:

  • All: every transaction marked Unpaid, paid or not
  • Unpaid: transactions with no Paid or Received Date yet. This is what’s still outstanding.
  • Paid: transactions that have since been paid or received

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.

Account Reconciliation Two ways to review your account balances. Use one or both.

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!

Option 1

Accounts Custom tab

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

  • Input the “From” and “To” date.
  • The opening balance reflects all activity before the “From” date, plus the opening balance entered in the Setup tab.
  • It pulls all transactions in the Transaction Log within the selected date range and calculates the ending balance for each account.
Option 2

Accounts Reconciliation tab

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

  1. Select the Account: scroll to the Input Section on the far right of the tab and choose the account from the drop-down menu. The list comes from your account setup in the Setup tab.
  2. Enter the Statement Start & End Date exactly as shown on your bank or credit card statement.
  3. Enter the Statement Balance: the ending balance from your statement.
  4. Let the template do the rest: it pulls every transaction from your Transaction Log within the statement period, calculates the ending balance and compares it to the statement balance you entered.
  • If the difference falls within the tolerable range ($), the account displays “Reconciled.” You can set this range at the top of the Input Section.
  • If it displays “Unreconciled,” review your Transaction Log to ensure all transactions have been entered correctly, including any unpaid items that now have a Paid or Received Date.
Both options include
  • Current View: the opening balance reflects the first day of the template start date defined in the Setup tab, and pulls all transactions from the beginning of the year up to and including today’s date to calculate the ending balance for each account.
  • Summary Charts: key metrics are summarized at the top of the tab for a quick overview, and two charts on the left show total cash flow activity and ending balances across all accounts.

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.

Sales Tax Reporting Sales tax collected and paid, by month.
No manual input required (other than the year)

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.

  • Total income and tax collected on your sales
  • Total expenses and tax paid on your purchases
  • Net tax: tax collected less tax paid, for each month and the year

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.

Balance Sheet Enter your month end balances once your books are done.

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.

At the end of your fiscal year

Since this is a multi-year template, the Balance Sheet doesn’t roll forward on its own.

  1. Save or export a copy of your completed Balance Sheet for your records.
  2. Clear the balances in the template.
  3. Start the new year with fresh opening balances.

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.