Over 4.5 million customers use QuickBooks.
Sign up for a free trial!
2020-06-10 19:23:18AccountantsEnglishhttps://quickbooks.intuit.com/au/resources/au_qrc/uploads/2020/06/Screen-Shot-2020-06-11-at-1.41.58-pm.pnghttps://quickbooks.intuit.com/au/resources/accountants/everything-you-need-to-get-started-with-quickbooks-firm-ledger/Everything you need to get started with QuickBooks Firm Ledger

Everything you need to get started with QuickBooks Firm Ledger

2 min read

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.

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.

Rate This Article

This article currently has 5 ratings with an average of 2.4 stars

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Help Your Business Thrive

Sign up for our newsletter

Thanks for signing up!

Check your inbox for a confirmation email.*

*Check your spam folder if you don’t see a confirmation email.

Related Articles

The 50 best small business apps organized by what you want to accomplish

We won’t sugarcoat it: you have a lot to get done. It’s…

Read more

Free business proposal template: 10 steps for small business owners

Free business proposal template: 10 steps for small business owners Winning a…

Read more

Five steps to create and launch your small business website

Welcome to the internet! You’ve made it this far, so we’re guessing…

Read more