Smash tax time, with our once a year EOFY sale!
Get started from $2*
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.
A picture of a person that is holding a plant.
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

Looking for the full package?
Engage with the QuickBooks suite to unlock additional price benefits for Simple Start subscriptions

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.

Stay up-to-date with the latest small business insights and trends!

Sign up for our quarterly newsletter and receive educational and interesting content straight to your inbox.

Want more? Visit our tools and templates!

By signing up you are agreeing to our terms and privacy policy.

A happy small business owner signing up for the QuickBooks newsletter on laptop