Skip to content

Start your books

Starting your books takes five steps, opened from Set up books in Settings › Books: Start, Chart, Accounts, Opening balances and Review. Nothing is saved until you click Start books on the last step. What you choose is kept if you close Settings and come back, and Cancel asks before throwing it away.

Who can do this

For now, BaseCloud support starts your books with you. Ask BaseCloud support to start your books. Have your start date, your financial year end and your trial balance from your old system ready.

Moving from Xero, QuickBooks or Sage? Start your books with the chart imported from there (step 1), then use Move from Xero, QuickBooks or Sage to bring over your clients, open invoices, payments and trial balance. See Moving to BaseCloud from another accounting system.

1. Start

Where your chart comes from

Under Where does your chart of accounts come from? pick one:

Choice What you get
The standard chart for your country A ready-made chart for the United States (four-digit codes, such as 1200 Accounts Receivable and 4100 Service Revenue) or South Africa (three-digit codes, such as 610 Accounts Receivable, 200 Sales and 820 VAT). The numbers follow Xero's standard charts, so they'll look familiar.
Import it from Xero Your accounts, account codes and tax rates, copied from your Xero organisation. Pick the connection, then the organisation.
Import it from QuickBooks Your accounts and account codes from your QuickBooks company. Credit card accounts come over as bank accounts, ready to reconcile. QuickBooks keeps US sales tax rates per agency, outside the chart, so add your rates in Chart of accounts afterwards: the import tells you so on Chart.
Import it from Sage Your accounts and VAT rates from your Sage Accounting company. Sage has no account numbers, so BaseCloud numbers them by type. Pick the connection, then the company.

An import only reads. Nothing is changed in Xero, QuickBooks or Sage.

Pick the connection to import from in Connection. Not connected yet? Open Connection and pick + New Connection to sign in to Xero, QuickBooks or Sage without leaving the setup. If the connection you pick has expired, a Reconnect button appears under it: sign in again and carry on. These are the same steps as Settings → App Connections & Keys, where your connections are also listed.

Start date

Your start date is the day your books begin in BaseCloud. Accountants call it the conversion date.

  • Invoices dated on or after the start date post into Books, one by one.
  • Everything before it comes in as one set of opening balances, dated the day before.

Pick a date your old system has closed off cleanly. Usually that's:

  • the first day of a month, or better, the first day of your financial year (January 1 for most US businesses, March 1 for many South African ones), and
  • the day after the last period you've closed in your old system, so your opening balances come from figures that won't change.

For example, if your books in QuickBooks are closed to December 31, 2026, start on January 1, 2027, and take your opening balances from QuickBooks' trial balance as at December 31, 2026.

The start date can be today or earlier, but not in the future, and not before 2000.

The start date can't move

Once your books are on, the start date is fixed. Changing it means removing the books and setting them up again. Check it with your accountant before you start.

Financial year ends on

Pick the month and day your financial year ends: December 31 for most US businesses, the last day of February for many South African ones. Your reports' year presets run to this day, and each year's profit moves into Retained Earnings after it. See Year end.

  • Importing from Xero or QuickBooks? It's filled in from there, and says Taken from Xero (or QuickBooks).
  • Otherwise, until you pick one, it is the day before your start date, so your first year runs from the start date.

You can change it, and the basis below, later in Settings › Books. See Lock dates.

Reports open on

Pick the basis your books' reports open on:

  • Accrual: income when invoiced. A sale counts on the invoice's date, whether it's paid or not. Most businesses, and Xero and QuickBooks, use this.
  • Cash: income when paid. A sale counts when the money comes in.

Each report card can still show the other basis. See Books reports.

Click Next. BaseCloud checks your invoices for the next steps.

2. Chart

Chart lists every account in the chart you picked, grouped by kind (assets, liabilities, equity, income, expenses), with its code, name and type. Search it by code or name. Accounts added for you are marked New.

Check each account's type: it decides whether the account is on your profit and loss or your balance sheet. A type can still be changed in Chart of accounts after switching on, while only opening balances are posted to it.

If your old chart is missing an account Books needs, Books adds it and says so in a note at the top: Accounts Receivable, Sales Tax or VAT, Undeposited Funds, Rounding, Opening Balance Equity, Retained Earnings, Historical Adjustment, Bad Debts or Suspense. See the accounts Books uses by itself.

3. Accounts

Each code your invoice lines have used is listed with how many lines use it and what it is (the Standard Line Item it belongs to). Each one goes to an account.

  • A code that matches an account in your chart by code or by name is filled in for you and marked Matched. A bank account, or an account only Books posts to, is never filled in: a line coded 1000 isn't money in the bank.
  • A code that is a bank account (Chase Checking, say) is marked Bank account and goes to Returned checks, which setup adds to your chart for it. QuickBooks bills a customer again for a check that bounced with a line straight on the bank account. Invoice lines can't go to a bank account here, and on sales the bounced money would count as income. The invoice puts the money back on what the customer owes, and when the bounce shows on your bank statement, code that line to Returned checks too: it comes back to zero.
  • Everything else (product codes, SKUs, blanks) starts on your sales account and is marked Check. Change it where it belongs somewhere else: INSTALL to Service Revenue, PARTS to Sale of Goods, and so on.
  • Search for a code, a name or an account, and Show only the codes To check or those Matched.
  • Tick several codes (or Tick all) and pick one account under Send them all to to set them in one go.
  • Missing an account? Pick New account… at the top of the list (see Add an account during setup). Keep different kinds of income apart this way, such as subscriptions and once-off work.
  • When several codes go to the same account, a note says so: from then on your reports show them together.

When your books start, a line's code becomes its account, as in Xero: every invoice, quote and credit note line (old ones too), Standard Line Item, recurring line and Pricebook item takes the code of the account you picked, and report cards and automations that filter on a code follow. A Pricebook item with no code of its own keeps following its category. A report card filtering on lines with no code keeps that filter: change it if it should now be an account. Amounts don't change, and customers never see codes: invoices and quotes don't print them. The old codes are kept, so a line that still arrives with one (from an automation, say) goes to the account it became, or, when the Standard Line Item that had that code has since been pointed at another account, to that one. From then on, a line's Account is a choice from your chart.

Which tax rate are these lines?

When two of your tax rates have the same percentage (a state rate and a county rate that are both 6%, say), your books can't tell which one your existing lines charged. A box lists Lines at each shared percentage: pick the rate each should be, so your sales tax report shows them. Lines you leave need their rate picked on each invoice.

Automations that make quotes or invoices

Once your books are on, every invoice line needs an account. Automations whose Create Quote / Invoice step would make lines with no account are listed here with what's wrong. Pick the account their lines go to when a line has no code that names one. BaseCloud saves it with the automation, so those invoices aren't refused after you switch on.

Automations that compare a code

Automations that hold one of your codes (an If Statement value or a Key Match key such as 1000/200) are listed. Those marked (updated) compare it with a line's code ({{item_code}}) and are changed to the new account code when your books start. Those marked (change by hand) compare something else, such as If {{amount_total}} > 1000, so they are left as they are: check those yourself.

Add an account during setup

Every account list in the setup, on the Accounts step and on Opening balances, offers New account… (or New account). It opens one form, the same everywhere:

  • Type: from the Accounts step, any type a line can post to; from Opening balances, every type, a bank account first.
  • Code: the next free code for that type, the way your chart is numbered (after 1000 comes 1001; after 090, 091). Change it if you like. It can't be a code already in the chart, contain |, or be blank.
  • Name.
  • For a bank account, its account number (optional; only the last four digits are kept). It is in your books' currency.

The account appears in every list in the setup, among the chart's accounts in code order, marked New, and under Accounts you're adding, where you can remove it again. If a code or an opening balance uses it, BaseCloud asks first. Nothing is saved until you click Start books.

If you go back and change the chart (from the standard chart to an import from Xero, say) and the new chart already has a code you added, your account is taken off: the chart's own account keeps the code. BaseCloud tells you which, and any code or opening balance that used it needs an account picked again.

4. Opening balances

Enter each account's balance on the day before your start date, from your old system's trial balance at that date. Every account in your chart is listed with Debit and Credit boxes. Fill in the accounts that have a balance and leave the rest blank.

  • Paste a trial balance: copy the rows from your old system's trial balance, or from a spreadsheet (the account code or name, then the debit and credit columns, or one balance column), paste them in and click Fill in the balances. Each row is matched to an account by its code, then by its name, and fills the grid. Rows that match no account are listed: type those in by hand, or add the account with New account.
  • Choose a CSV file does the same from a file saved from your old system or a spreadsheet.
  • Type amounts the way your trial balance shows them: 18,250.00 and 18250 both work.
  • Search by code or name, or tick Only accounts with a balance to check what you've entered.
  • Under each account it says which side it usually has ("usually a debit"). A balance on the other side is allowed (an overdrawn bank account is a credit), but BaseCloud points it out, and Review asks you to check it.
  • Clear all empties the grid.

Debits are what you have or are owed (bank, equipment); credits are what you owe and what was put in (loans, sales tax, equity). The Total, every account row shows both sides.

Moving over from Xero or QuickBooks with the same connection? You can leave this step blank: after setup, the move brings their trial balance in as your opening balances.

An account that isn't in your chart yet, such as a second bank account, a savings account, a credit card or a loan, is added with New account (how).

Bank accounts are ready to reconcile. Each bank account you give an opening balance, and each one you add here, gets its bank account when your books start, ready to reconcile.

Checks and deposits not yet through the bank. Your books' bank balance on the day before the start can differ from your bank statement's, because of checks you wrote and deposits you made that hadn't cleared yet. When a bank account has a balance, type the statement's figure in Bank statement said (leave it blank when it is the same). The bank account then starts at the bank's figure, so your first reconciliation matches the statement, and the difference is held in an account called Uncleared items at the start. When those checks and deposits come through on the statement, code them to that account in Bank reconciliation and it comes back to zero.

If you start partway through your financial year, include your income and expense accounts' balances for the year so far too, so this year's figures are complete.

Accounts Receivable is filled in for you. It's worked out customer by customer from your records before the start date, and shown at the top of the grid:

  • every invoice dated before the start date (not void),
  • less every credit note dated before it,
  • less the payments the customer made before it, after any refunds you paid back before it.

So a part-paid invoice opens with what was still owed, and a customer who had paid ahead opens with their credit (a credit balance). Each customer's balance is right from day one, and those invoices can still be collected. You can't type it.

Accounts Payable is typed in, for now. Enter what you owed suppliers at the start date, from your old system's aged payables. Until bills arrive in Books, pay it down with spend money on Accounts Payable when you pay a supplier.

Check receivables first

Before you start, make sure what BaseCloud says each customer owes is what they really owe. Record any payment you've received, with the date it was paid, and credit or write off anything that won't be paid. A statement for the day before your start date shows each customer's balance. Your opening Accounts Receivable is the total of what's left.

If your debits and credits don't match (often because Accounts Receivable in BaseCloud differs a little from your old system's), BaseCloud says by how much: the difference goes to Historical Adjustment. You can see it there, and clear it later with a manual journal. Ask your accountant where it belongs before you clear it. If it's there because some old invoices, credit notes or payments aren't in BaseCloud yet, bring them over instead: each one moves the difference, and it reaches zero by itself once they're all in.

Example

A US business starting on January 1, 2027, with this trial balance from QuickBooks at December 31, 2026:

Account Debit Credit
1000 Business Bank Account 18,250.00
1200 Accounts Receivable 6,400.00
2230 Sales Tax 530.00
3000 Retained Earnings 24,120.00

They paste the trial balance in. The bank, sales tax and retained earnings lines fill in; Accounts Receivable comes from their open invoices. If those add up to $6,400.00, everything balances. If they add up to $6,350.00, the $50.00 difference goes to Historical Adjustment for their accountant to look at.

In South Africa it works the same way in rand, with accounts such as 610 Accounts Receivable and 820 VAT.

Got one wrong, or found a balance later? You can change the opening balances after the books are on.

5. Review and start

Review shows:

  • your start date, financial year end and reporting basis;
  • the chart and how many accounts it has, how many codes become accounts, and the tax rates that will be made;
  • how many invoices, quotes, credit notes and payments will be posted when you switch on, and how many documents from before the start date are part of your opening balances;
  • your opening balances, and anything going to Historical Adjustment;
  • What customers owe at the start date, by age (how many customers and how much, from current to over three years). If much of it is on invoices more than three years old, a warning suggests writing off what will never be paid after switching on;
  • the new accounts you added, and the bank accounts that will be made, ready to reconcile;
  • notes from an import, and how many automations you gave an account;
  • a warning when your chart's currency differs from your invoices' currency. Books are kept in one currency, and it can't be changed later without removing them.

Click Start books. BaseCloud then:

  1. Creates your chart of accounts, with the accounts you added, and your tax rates.
  2. Links your invoice lines, Standard Line Items, recurring lines and Pricebook items to their accounts, and writes the accounts you picked into your automations.
  3. Posts your opening balances, dated the day before the start date, and makes the bank accounts listed on Review.
  4. Posts every invoice and credit note dated on or after the start date, and every payment and refund made on or after it.
  5. Makes a Books dashboard on the Reports page with your profit and loss, balance sheet, what you're owed, sales tax and cash. See Books reports.

Settings stays open until it's done; it can take a few minutes. When it's finished, Your books are on sums up what was made and posted.

A lot of invoices? When there are more than about 2,000 documents and payments to post, BaseCloud makes your chart and opening balances first and posts the rest in the background. Settings › Books says Still posting your invoices and payments until it's done (click Check again). Reports and account balances are complete once it has finished.

Anything that couldn't be posted is listed in Settings › Books with the reason (often a line with no account). Open each one, fix what it says and save it, and it posts. The list stays until they have all posted.

From then on, every invoice and payment posts as you save it. See How invoices post. Every night BaseCloud also checks that everything has posted and fixes what it can. If it finds something it can't fix, Settings › Books says so and names the document.

Invoices from before the start date

An invoice dated before your start date is part of your opening balances. It never posts to sales or tax.

  • If it was open at the start date, it's in your opening Accounts Receivable. When it's paid, the payment posts as usual. You can credit it with a credit note dated after the start date.
  • Your opening receivables follow your documents. Adding, editing, voiding or paying an invoice, credit note or payment dated before the start date moves that customer's opening Accounts Receivable, with an Opening balance change journal against Historical Adjustment. So you can bring your old system's documents over before or after your books are on. See Moving to BaseCloud from another accounting system.
  • Once a lock date is set, these can't be added, edited or voided any more, because that would change opening balances you've checked. If one is wrong then, fix it with a manual journal, with your accountant's help, or clear the lock date first.