Import Journal Entries into QuickBooks Online
Bulk import journal entries into QuickBooks Online from Excel, CSV, text or IIF files. Every entry is checked to balance before it posts, with classes, locations and names on each line.
- Free plan, no credit card needed
- Balanced before posting
- Preview before you post
Intuit Gold Partner
SOC 2 Type II audited
1,000+ Five-Star Reviews
- Marketing ExpenseMain St1,250.00
- Marketing ExpenseOak Ave1,250.00
- Marketing ExpenseElm Park1,249.99
- Prepaid ExpensesHQ3,750.00
Off by $0.01 · held for review
- !Debits equal credits
- ✓Every account found
- ✓A location on every line
QuickBooks OnlineJournal entriesSample- PR-1106Payroll$9,064.13✓ Posted
- AJ-1031Rent accrual$4,200.00✓ Posted
- AL-1102Shared cost allocation$3,750.00Held
A QuickBooks Online Journal Entry Import That Checks Every Line
Payroll journals, allocations and month-end adjustments run to dozens of lines, and each one is typed by hand.
Where Entering Journal Entries by Hand Falls Short
Every line goes in one at a time, account by account. One wrong line and the entry won't save, or worse, it saves to the wrong account.
- 1Wages Expense8,420.00
- 2Payroll Tax Expense644.13
- 3Payroll Liabilities1,288.26
- 4Checking7,775.78
Out of balance by $0.09. The entry won't save.
Can You Import Journal Entries into QuickBooks Online?
Yes, with Autymate Transactions. It imports journal entries into QuickBooks Online in bulk from Excel, CSV, delimited text and IIF files. Rows that share a journal number become one entry, every entry is checked so debits equal credits, and each account is matched by name. You preview the batch, and entries that balance post when you approve them. Any that don't are held with the difference shown.
Import my journal entriesJournal Entries from Wherever They're Prepared
Pick where your entries come from. Each one lands in QuickBooks Online as a balanced journal entry, line for line.
Excel
XLS/XLSXJournal entryMonth-end workpapers and adjustment schedules, uploaded as they are.
Import from ExcelCSV
CSVJournal entryGL exports from payroll, ERP or consolidation tools.
Import from CSVGoogle Sheets
SheetJournal entryA shared journal tab, downloaded as Excel or CSV and imported the same way.
Google Sheets optionsIIF
GENERAL JOURNALJournal entryJournal blocks from payroll providers and Desktop-era systems.
Import from IIFTXT and Other Delimited Files
TXTJournal entryTab, pipe or semicolon GL files from older systems.
Get started for freeTrial Balance
TBOpening entryOpening balances from your old books in one entry.
Import trial balance into QuickBooks Online
Payroll Providers
Pay runJournal entryWages, taxes and liabilities by location after every pay run.
Talk to an expert: Payroll ProvidersPOS Daily Summaries
Daily closeJournal entrySales, tax, tips and fees as one summary entry per day.
Talk to an expert: POS Daily SummariesFixed Assets & Depreciation
ScheduleJournal entryMonthly depreciation and amortization.
Talk to an expert: Fixed Assets & DepreciationFranchisor Royalties
StatementJournal entryRoyalty and ad fund accruals in each location's books.
Talk to an expert: Franchisor RoyaltiesERP & Consolidations
GL exportJournal entryIntercompany and allocation entries across companies.
Talk to an expert: ERP & ConsolidationsYour Own System
CustomJournal entryWe build the connection with our custom integration team.
Talk to an expert: Your Own System
Entries coming from a system we don't connect to yet? Talk to an expert about a custom integration
Pick Up Journal Files Automatically
Connect Google Drive, an SFTP folder or Amazon S3, and new journal files are picked up and queued for your review. Or pull journal entries from any system with a custom API.
- Google Drive
- SFTP folder
- Amazon S3
- Custom API
Every Line, Balanced and Tracked
The detail your reports need on every line, not just the totals for each entry.
- Journal no.
- PR-1106
- Date
- 11/06/2026
- Account
- Wages Expense
- Debit
- 8,420.00
- Credit
- —
- Name
- —
- Description
- Wages, pay run 11/06
- Class
- Payroll
- Location
- Main St
Multi-Line Entries
Rows that share a journal number become one entry, however many lines it has.
Balance Check
Debits must equal credits before anything posts.
Names on A/R and A/P Lines
Customers and vendors on receivable and payable lines, as QuickBooks requires.
Classes and Locations
Each line tagged, so P&L by location stays right.
Journal Numbers
Your own numbers kept, so entries match your workpapers.
Line Descriptions
Memos on every line, for the audit trail.
Adjusting Entries
Month-end and year-end adjustments marked as adjusting.
Dates and Periods
Entries checked against your QuickBooks closing date.
Start Importing
Free plan, no credit card needed.
Get Started for Free
QuickBooks Online's Journal Entry Import vs Autymate
QuickBooks' built-in import handles a small, clean file. These are the limits people hit next.
| QuickBooks Online built-in import | Autymate Transactions | |
|---|---|---|
| Rows per import | Spreadsheets under 1,000 rows | Larger files, no manual splitting |
| File types | A CSV file | Excel, CSV, delimited text and IIF, from Google Drive, SFTP, S3 or any API |
| Unbalanced entries | Fix the file, then import it again | Held with the difference shown; the rest posts |
| Missing accounts or names | Add new accounts to the chart of accounts first | Flagged, then mapped; missing customers can be created |
| Duplicates on re-run | Only the duplicate journal number warning, if it's on | Entries already posted are skipped |
| Saved mappings and scheduling | A manual upload each time | Yes, for recurring entries like payroll |
To bulk import journal entries, QuickBooks Online has its own CSV import under Settings, Import data. Its column above follows Intuit's help articles, checked November 2026. Features can vary by plan and region. Sources: Intuit: Import journal entries (opens in a new tab) · Intuit: Common questions about importing data (opens in a new tab)
How to Set Up Your Journal Entry File
Use the workpaper you already have. These habits make every import cleaner.
One row per line. Repeat the journal number and date on each line of the same entry.
Debit and credit in separate columns, or one signed amount column. Both work.
Every entry balances. Total debits equal total credits for each journal number.
Add a name to A/R and A/P lines. QuickBooks requires a customer or vendor on those accounts.
Accounts as they appear in QuickBooks, by name or number.
You don't need a fixed journal entry import template: QuickBooks Online fields are matched to your own column headers on the mapping screen.
JournalNo,Date,Account,Debit,Credit,LocationPR-1106,11/06/2026,Wages Expense,8420.00,,Main StPR-1106,11/06/2026,Payroll Tax Expense,644.13,,Main StPR-1106,11/06/2026,Payroll Liabilities,,1288.26,Main StPR-1106,11/06/2026,Checking,,7775.87,Main StBalanced, so it posts
How Journal Columns Map to QuickBooks Online
Autymate suggests the mapping from your headers. Change any field, set defaults, and save it for next time.
Saved for Next Time
Map a payroll or month-end layout once. Each run keeps a copy of the mapping it used, and every change is versioned.
| Your column | QuickBooks Online journal field | Notes |
|---|---|---|
JournalNo | Journal no. | Groups lines into one entry, and is how a re-run is recognised |
Date | Journal date | Checked against your closing date |
Account | Account | Matched by name or number |
Debit / Credit | Debits / Credits | Or one signed Amount column |
Name | Name (customer, vendor or employee) | Required on A/R and A/P lines |
Description | Description | Line memo |
Location / Class | Location / Class | Kept when tracking is on in QuickBooks Online |
Adjusting | Is adjusting journal entry | Yes / No |
Memo | Memo | Entry-level note |
How to Import Journal Entries into QuickBooks Online
Five steps, a few minutes for the first file. After that, saved mappings make recurring entries one upload.
Sign up for Autymate Transactions and connect your QuickBooks Online company with your Intuit sign-in. Autymate never sees your QuickBooks password.
QuickBooks Online connected as the destination. Pick Journal Entry as the record type, then add your source: an Excel, CSV, text or IIF file.
Journal Entry sits under Accounting in the record-type picker. Autymate matches your headers to QuickBooks Online journal fields. Fix any account that's named differently in QuickBooks Online, such as Wages for Wages Expense.
Each journal field, the column it takes, and the value it will get. See each entry with its debit and credit totals. Unbalanced entries and missing names on A/R or A/P lines are flagged before anything posts.
Every entry's debits and credits before it posts. Entries that don't balance are held. Post to QuickBooks Online and check results by journal number. Fix any held entries and re-run; entries already posted are skipped.
What posted, and what is held for review.
Common Journal Entry Import Errors, Handled
The issues that usually stop a journal entry import, and what Autymate does about each one.
| What you see | Why it happens | What Autymate does |
|---|---|---|
| Entry doesn't balance | Debits and credits for a journal number don't match, often by a rounding cent. | Holds the entry, shows the difference, and posts the rest. |
| A/R or A/P line without a name | QuickBooks requires a customer on receivable lines and a vendor on payable lines. | Flags the line so you can add the name before the entry posts. |
| “Account doesn't exist” | The account name or number isn't in your chart of accounts. | Matches accounts by name first. If none matches, the entry is held so you can map it to an existing account. |
| Date in a closed period | The entry falls before your QuickBooks closing date. | Flags it before posting, so closed books stay closed. |
| Duplicate journal number | The same file, or the same entry, is imported a second time. | Recognises entries it already posted and skips them. |
| Lines split across entries | One entry's lines have different dates or numbers. | Groups lines by journal number and flags lines that don't match. |
Who Imports Journal Entries into QuickBooks Online
Six teams, six recurring entries. Each one is a file they already have, imported instead of typed.
Accountants & Bookkeepers
Month-end and year-end adjustments from workpapers, posted in one run per client.
Import adjusting journal entries QuickBooks Online
Payroll Journals
Every pay run's wages, taxes and liabilities, split by location.
Import payroll journal entry QuickBooks Online
Multi-Location Businesses
Allocations of shared costs across locations and classes.
Import allocation entries QuickBooks Online
Franchisees
Royalty and ad fund accruals recorded every period.
Import royalty accruals QuickBooks Online
Switching to QuickBooks Online
Opening balances from a trial balance in one entry.
Import opening balances QuickBooks Online
Controllers & CFOs
Depreciation, accruals and intercompany entries on a schedule.
Import recurring entries QuickBooks Online
Import Journal Entries for Less
Start free with one location. Move to Standard when you need more rows or more locations.
Free
Start here$0no card required- 1 location
- 200 rows a month
- Preview, undo and saved mappings
Standard
$19per location, per month- Unlimited locations
- 30 runs a month
- Everything in Free
Every new account starts on Free, so you can connect QuickBooks Online and post real journal entries in your first session. Get started for free
| Autymate Transactions | SaaSAnt Transactions (Growth) | |
|---|---|---|
| Monthly price | $19/mo | $25/mo |
| Bulk journal entry import to QuickBooks Online | Yes | Yes |
| Excel, CSV, Google Sheets & IIF | Yes | Yes |
| POS & app connections (Toast, Square, Clover…) | Yes | No |
| Get started | Start for Free | — |
SaaSAnt price from SaaSAnt's published Growth plan, checked November 2026. Prices may change.
Importing Journal Entries into QuickBooks Online
Yes. Autymate Transactions bulk imports journal entries from Excel, CSV, delimited text and IIF files, checks that each one balances, and posts them with classes, locations and names on every line.
Connect QuickBooks Online to Autymate Transactions, choose Journal Entry as the record type, upload your file, map the columns, preview the balances, then import. The run lists what posted by journal number, and any held entry with its reason.
Yes. Upload the .xlsx or .xls workbook as it is, with no saving to CSV first. Autymate reads each row as a journal line, groups the lines by journal number and matches your column headers to QuickBooks Online fields.
One row per line, with the journal number and date repeated on each line of the same entry. Use separate Debit and Credit columns, or one signed amount column.
The usual causes are an entry that doesn't balance, an A/R or A/P line with no customer or vendor, an account that isn't in QuickBooks, or a date before your closing date. Autymate flags each one before posting.
Yes. QuickBooks Online requires a customer on accounts receivable lines and a vendor on accounts payable lines. Autymate flags any line where one is missing, so you can add the name before the entry posts.
Yes. Add an Adjusting column with Yes or No, and Autymate marks the entry as adjusting in QuickBooks Online.
Yes. Import your trial balance as one journal entry dated the day before you start in QuickBooks Online, with each account's balance on its own line.
Yes. Save the mapping once, then run it after every pay run: on a schedule, when you upload the file, or automatically when the file lands in a watched SFTP folder.
Autymate remembers every entry it has posted, so re-running a file skips the entries already in QuickBooks Online instead of creating duplicates.
Autymate Transactions is $19 per location per month, and you can get started for free: the Free plan needs no card and covers one location and 200 rows a month.
Stop Typing Journal Entries Line by Line
Bulk import balanced journal entries into QuickBooks Online today. Start free, no credit card needed.
- Create your free account
- Connect QuickBooks Online
- Upload your journal file
- Intuit Gold Partner
- SOC 2 Type II audited
- 1,000+ Five-Star Reviews
QuickBooks OnlineSample✓ 61 posted3 held for review