# Moving to Briefcase Ledger from Sage Accounting

> Canonical page: https://briefcase.so/articles/moving-to-briefcase-ledger-from-sage-accounting
> Briefcase content index: https://briefcase.so/llms.txt

Move a limited company from Sage Accounting by uploading reports you export from Sage. Briefcase Ledger takes over on your start date, with the balances, last…

Updated 8 Nov 2026

Move a limited company from Sage Accounting by uploading reports you export from Sage. Briefcase Ledger takes over on your start date, with the balances, last year's history, unpaid invoices and bills, and customers brought across.

Moving from Sage 50, the desktop software? Follow [Moving to Briefcase Ledger from Sage 50, FreeAgent or a spreadsheet](https://briefcase.so/articles/moving-to-briefcase-ledger-from-sage-freeagent-or-a-spreadsheet) instead.

## Before you start

-   **Choose the start date.** For a VAT-registered company, it's the day after the last VAT period Sage files. If Sage files the quarter to 30 June, Briefcase Ledger starts on 1 July. Run every report as at the day before the start date.

-   **VAT:** Briefcase Ledger supports standard (accrual) VAT accounting. A company on the cash accounting scheme or the Flat Rate Scheme can't be imported yet.

-   **Permission:** you need **Financial Close → Create**.

## What to export from Sage Accounting

|
Report

 |

Where to find it

 |

How to run it

 |
| --- | --- | --- |
|

**Trial Balance** (required)

 |

Reports → All reports → Trial Balance, then **Try the new report**

 |

As Of the day before the start date. Export as CSV or Excel.

 |
|

**Audit Trail**

 |

Reports → All reports → Audit Trail

 |

Choose **Detailed**. Set the period to **Custom**, from the first day of last financial year to the day before the start date. Under **More**, set Status to **Exclude deleted**. Export as CSV.

 |
|

**Customers**

 |

Contacts → Customers

 |

Select the arrow next to **New customer**, then **Export all**.

 |
|

**Aged Debtors** and **Aged Creditors**

 |

Reports → All reports

 |

Set the date to the day before the start date, select **Calculate**, then **Detailed**. Export each as CSV.

 |

Only the trial balance is required. The Audit Trail brings in last year's history, so monthly reports and comparatives work from day one. The aged reports bring in every invoice and bill still unpaid. Each step of the wizard shows the exact dates to use.

Sage puts each export in **Notifications**, the bell on its top bar. Download the file from there.

Use the new Trial Balance report. The one that opens first is Sage's old report, which can count earlier years' profit and loss in this year's figures, so Briefcase won't import it.

## 1\. Start the import

On the dashboard, click **Add client**, choose **Limited companies**, then **Import from another system**. The wizard saves your progress in this browser, so you can leave and come back.

![The Add client window with Import from another system and Create new](https://kb-assets.briefcase.so/support-kb/uploads/ckt14x6e8b06d3mq6ekhu0n3-ledger-import-start.png "Import from another system")![The Add client window with Import from another system and Create new](https://kb-assets.briefcase.so/support-kb/uploads/wyoimmg5671c89tfp1z5mfia-ledger-import-start-dark.png "Import from another system")

## 2\. Company

Enter the company name, its Companies House number if you have it, and its financial year end, and choose **Sage Accounting**.

![The Company step with Sage Accounting chosen and the reports to have ready](https://kb-assets.briefcase.so/support-kb/uploads/mgk139du7d281y40lk49xvyl-ledger-import-sage-company.png "Company")![The Company step with Sage Accounting chosen and the reports to have ready](https://kb-assets.briefcase.so/support-kb/uploads/js89jacybmf77b2k5y7qtilw-ledger-import-sage-company-dark.png "Company")

## 3\. Start date

If the company is VAT registered, enter its VAT number, how often it files, its accounting scheme and when the last VAT period Sage files ends. Briefcase Ledger starts the next day, so no VAT period is split between Sage and Briefcase. If it isn't VAT registered, pick any start date: the first of a month keeps each month in one system.

If the start date begins a new financial year, say whether the trial balance is from **Before the close** (it still shows last year's sales and expenses) or **After the close** (its profit and loss rows are nil).

## 4\. Trial balance

Upload the Trial Balance. Check that it says **balanced** and click **Continue**. Sage's **Profit And Loss - Prior Years** line (3XXX) is earlier years' profit, and goes to Retained Earnings.

![The Trial balance step showing the accounts read from Sage's new Trial Balance report](https://kb-assets.briefcase.so/support-kb/uploads/v17rvtthig9dveib1tnavx77-ledger-import-sage-trial-balance-v2.png "Trial balance")![The Trial balance step showing the accounts read from Sage's new Trial Balance report](https://kb-assets.briefcase.so/support-kb/uploads/ps4g7cs78gtdp72cvkhzygfa-ledger-import-sage-trial-balance-v2-dark.png "Trial balance")

## 5\. History (optional)

Upload the Audit Trail. Briefcase reads every transaction and checks them against the trial balance before anything is imported. A large company can export each year separately and upload both files. History doesn't affect VAT returns.

![The History step with the Audit Trail read: 300 journals over 15 months](https://kb-assets.briefcase.so/support-kb/uploads/lb226rg13x1s07h5xm19sg8q-ledger-import-sage-history.png "History")![The History step with the Audit Trail read: 300 journals over 15 months](https://kb-assets.briefcase.so/support-kb/uploads/shak4tt1b2p1tqu5vnz4f10y-ledger-import-sage-history-dark.png "History")

## 6\. Accounts

Each of Sage's accounts comes across with its own nominal code and name. Debtors, creditors, VAT, retained earnings, prepayments, accruals, deferred income and depreciation go into the accounts Briefcase runs on, still with Sage's nominal code and name unless several of your accounts merge into one.

Anything Briefcase isn't sure about is listed first, under **Check these accounts first**, with the reason: a row it couldn't place, a type Sage disagrees with, or an unsure match to one of the accounts Briefcase runs on. Change what's wrong, then click **Confirm** on each one. You can continue once they're all confirmed.

Bank accounts have their own section. Check each statement balance against the bank statement for the day before the start date: if it differs from Sage, Briefcase shows the uncleared amount. The sort code and account number are optional, but with them uploaded statements match the account automatically.

Every other account is grouped by where it lands: revenue, cost of sales, expenses, assets, liabilities and equity. On any row you can pick one of Briefcase's accounts instead of **Own account**, and set its type. To make an account a bank account, set its type to **Bank account**.

![The Accounts step with nothing to check, the bank account with its statement balance and optional sort code and account number, and the other accounts grouped by type](https://kb-assets.briefcase.so/support-kb/uploads/vliavn1apeqdl811ch1vnqw2-ledger-import-sage-accounts-v3.png "Accounts")![The Accounts step with nothing to check, the bank account with its statement balance and optional sort code and account number, and the other accounts grouped by type](https://kb-assets.briefcase.so/support-kb/uploads/wg88fzkiajthp4j5o6kim4ii-ledger-import-sage-accounts-v3-dark.png "Accounts")

## 7\. Customers (optional)

Upload the customers export so you can invoice them from Briefcase straight away. Customers marked inactive in Sage are left out. You don't need suppliers: Briefcase picks them up from your bills.

![The Customers step showing four customers read from the Sage export](https://kb-assets.briefcase.so/support-kb/uploads/luadle7gpynjndcjxz3yln76-ledger-import-sage-customers.png "Customers")![The Customers step showing four customers read from the Sage export](https://kb-assets.briefcase.so/support-kb/uploads/sksf36ef432zdcl9bdp9qo0z-ledger-import-sage-customers-dark.png "Customers")

## 8\. Open invoices and bills (optional)

Upload the Aged Debtors and the Aged Creditors, both in the Detailed view. Each should show **Matches Accounts Receivable** or **Matches Accounts Payable**.

![The Open invoices and bills step with both aged reports matching their accounts](https://kb-assets.briefcase.so/support-kb/uploads/odwtor1x45pd3lfx9ipp3yjb-ledger-import-sage-open-items.png "Open invoices and bills")![The Open invoices and bills step with both aged reports matching their accounts](https://kb-assets.briefcase.so/support-kb/uploads/vyrax1lz1ol097q8wyalcod0-ledger-import-sage-open-items-dark.png "Open invoices and bills")

## 9\. Review and import

Check the summary and click **Import**. Nothing is created until then. With history, posting takes a minute or two.

![The Review and import step summarising the opening position, customers, open items, history and VAT](https://kb-assets.briefcase.so/support-kb/uploads/xxvuadlk1akteu1doonkz26m-ledger-import-sage-review-v2.png "Review and import")![The Review and import step summarising the opening position, customers, open items, history and VAT](https://kb-assets.briefcase.so/support-kb/uploads/u7wvgx16cdxew4vkeixhd0hw-ledger-import-sage-review-v2-dark.png "Review and import")

If the import fails, nothing from the history is kept and the ledger is empty. Delete the company from your client list, then click **Back to review**: your answers and files are kept, so you can fix what failed and import again.

## After the import

The company's home page shows **Going live**, which ticks each step off as you finish it.

-   **Connect your bank feeds.** Each bank account's balance on the day before the start date is already in the ledger. Click **Connect** to link the account to its bank, so transactions from the start date arrive every day. Prefer not to link it? Upload its bank statements instead.

-   **Opening Balances** is already cleared if you brought in the aged reports. It shows how many unpaid invoices and bills came in, whether each report matches the trial balance and how many have been paid since the start date. If some bank items from before the start date hadn't cleared, it asks you to code those bank lines to Opening Balances as they arrive.

-   **Connect HMRC**, so VAT returns file from Briefcase Ledger.

-   **Lock the ledger** up to the day before the start date, so nothing before it changes by accident.

Under **Good to know** it lists reminders for your import, such as when the last VAT return from Sage is due.

![The company home page with the Going live checklist: the bank feed to connect, Opening Balances cleared with the invoices and bills brought in from Sage, Connect HMRC and Lock the ledger](https://kb-assets.briefcase.so/support-kb/uploads/h3zbl4ebxmwgucuigi5wwlxy-ledger-import-sage-next-steps-v2.png "What to do next")![The company home page with the Going live checklist: the bank feed to connect, Opening Balances cleared with the invoices and bills brought in from Sage, Connect HMRC and Lock the ledger](https://kb-assets.briefcase.so/support-kb/uploads/ntgtklx52kkfj8i4ax1hfx0h-ledger-import-sage-next-steps-v2-dark.png "What to do next")

Imported something wrong? Before you start working in the company, delete it from your client list and import it again.

### Clearing the unpaid invoices and bills

Each invoice and bill from the aged reports comes in with Sage's date, number and amount still owed, marked **Sage import**. There's no document behind it: it's one line of the aged report you uploaded, and its page says so.

![A bill brought in from Sage, showing the line of the Aged Creditors report it came from, with its category and VAT fixed to Opening Balances and No VAT](https://kb-assets.briefcase.so/support-kb/uploads/ztn9trpb8f2xni66hmrd5xk0-ledger-import-sage-imported-bill.png "A bill brought in from Sage")![A bill brought in from Sage, showing the line of the Aged Creditors report it came from, with its category and VAT fixed to Opening Balances and No VAT](https://kb-assets.briefcase.so/support-kb/uploads/bqzbsy170w2mubd2gjyx40au-ledger-import-sage-imported-bill-dark.png "A bill brought in from Sage")

They show on **Aged Debtors** and **Aged Creditors**, under a summary of what came in from Sage, what's been paid since the start date and what's still owed.

![Aged Creditors with the Brought in from Sage summary above the bills, one of them marked Sage import](https://kb-assets.briefcase.so/support-kb/uploads/hotc52onlymy4hpdsce5hr91-ledger-import-sage-aged-creditors-v2.png "The imported bills on Aged Creditors")![Aged Creditors with the Brought in from Sage summary above the bills, one of them marked Sage import](https://kb-assets.briefcase.so/support-kb/uploads/ykg57tt73c52npbbhzs9idvg-ledger-import-sage-aged-creditors-v2-dark.png "The imported bills on Aged Creditors")

When the payment comes through the bank feed, Briefcase suggests the matching invoice or bill. Reconcile it and the item drops off the aged report, as with any other invoice or bill. Have the original PDF? Attach it to the imported invoice or bill rather than uploading it again, or it comes in a second time.

These invoices and bills are coded to **Opening Balances** with no VAT, and that can't be changed: their sale or cost and VAT were already recorded in Sage, and they're in the trial balance and history you imported, so another category or VAT rate would count them twice.

If an aged report doesn't match the trial balance, the difference comes in as one invoice or bill to **Unallocated from Sage**, so Accounts Receivable or Accounts Payable still matches. It's usually an invoice or bill missing from the report: when you find it, change the contact and reference on that item to the missing one's. Can't trace it? Write it off with a manual journal.

## More in Moving to Briefcase Ledger

-   [How do I migrate to Briefcase Ledger?](https://briefcase.so/articles/how-do-i-migrate-to-briefcase-ledger)
-   [Moving to Briefcase Ledger from QuickBooks Online](https://briefcase.so/articles/moving-to-briefcase-ledger-from-quickbooks-online)
-   [Moving to Briefcase Ledger from Sage 50, FreeAgent or a spreadsheet](https://briefcase.so/articles/moving-to-briefcase-ledger-from-sage-freeagent-or-a-spreadsheet)
-   [Moving to Briefcase Ledger from Xero](https://briefcase.so/articles/moving-to-briefcase-ledger-from-xero)

## Still need help?

Email the support team with what you were trying to do and we'll get back to you.

[Email support](mailto:support@briefcase.so)[Browse the help centre](https://briefcase.so/help)
