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.
Import your chart of accounts
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.
Journal Entry Import
With QuickBooks Online’s import feature, you can easily import journal entries. We’ll show you how using a CSV or Excel file.
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:
- Account name
- Journal number
If your spreadsheet has new accounts, be sure to add them in your chart of accounts before importing
Step 2: Import your journal entries
- Select Settings ⚙️, then select Import Data.
- Select Journal Entries.
- On the Download page, select Browse.
- Note: If you need help formatting your journal entries, select Download a sample file.
- Find and select your CSV file. Select Open, then Next.
- 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.
- Select Next.
- Select Start import. If there’s an error, select Download and correct. Then, edit the file and try again.
- Select Done.
Once you’re done, you can use the search function to check and edit the journal entries.