Need help choosing a plan?
Created with Sketch. 1800 917 771 Schedule a call
Need help?
We're here for you.
Schedule call
Created with Sketch.
Image Alt Text
QuickBooks Online Accountant

Everything you need to get started with QuickBooks Firm Ledger

If you are researching new options for trusts, partnerships or SMSFs, QuickBooks Ledger is a great alternative with direct bank feeds to access your client’s real-time transaction information with 91% coverage. 

To get you started, below are the top three tools for your new QuickBooks Ledger subscription.

  1. Uncoded Transactions report
  2. Import your chart of accounts
  3. Journal Entry Import

Uncoded Transactions report

The Uncoded Transaction report will show you the transactions in the For Review tab of the Banking screen that have not yet been added/categorised to your books. 

Import your chart of accounts

QuickBooks uses your chart of accounts to organise all your accounting. When you set up your company, QuickBooks customises your chart of accounts for you.

Use a spreadsheet to import your accounts and skip manual entry. We’ll show you how.

Tip: The best time to import accounts is when you’re still setting up your company in QuickBooks. But if you don’t have a lot of accounts to add, you can create new accounts instead.

Full steps here

Journal Entry Import

Learn how to import journal entries in QuickBooks Online.

With QuickBooks Online’s import feature, you can easily import journal entries. We’ll show you how using a CSV or Excel file.

Full steps here

Step 1: Prep your spreadsheet

Before you import your journal entries, make sure everything looks correct in your spreadsheet which must be saved as a CSV file.

Fill in the required columns:

  • Date
  • Account name
  • Journal number
  • Debit
  • Credit

If your spreadsheet has new accounts, be sure to add them in your chart of accounts before importing

Step 2: Import your journal entries

  1. Select Settings ⚙️, then select Import Data.
  2. Select Journal Entries.
  3. On the Download page, select Browse.
  4. Note: If you need help formatting your journal entries, select Download a sample file.
  5. Find and select your CSV file. Select Open, then Next.
  6. Map your information. Your Field represents the headers on your spreadsheet. From each small arrow ▼ icon, select the one that matches a field in QuickBooks Online.
  7. Select Next.
  8. Select Start import. If there’s an error, select Download and correct. Then, edit the file and try again.
  9. Select Done.

Once you’re done, you can use the search function to check and edit the journal entries.

Related Articles

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Help Me Choose

Use our product selector to find the best accounting software for you.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.