Xargaar ToolsCheck every journal balances, then get a QuickBooks Online import file.
Drop in a CSV of journal lines from your spreadsheet or payout workings. See each journal checked to the cent: debits equal credits, one date, nothing unreadable. The pack writes the six-column file QuickBooks Online asks for. Nothing is uploaded.
Built from Intuit's published steps for importing journal entries. Tested only on made-up files, never on a live QuickBooks company, so the import itself is not guaranteed. Account names are copied as you write them: QuickBooks needs them to match your chart of accounts, and sub-accounts as "Parent: Sub". This is not tax or accounting advice.
Set these to match your files before you drop them. Nothing is guessed. Limits: 20 files, 40 MB each, 200 MB in total.
What it does
Finds the columns by header name and reads every date and amount strictly. A bad row stops the file with its row number.
Every journal must have at least two lines, one date, and debits equal to credits to the cent. Anything else blocks the downloads.
The pack writes Journal No., Journal Date, Account Name, Journal/Description, Debits and Credits, ready for QuickBooks Online's Import Data.
Pay once. Check and build every journal.
- All journals in your files instead of the first 3.
- The QuickBooks Online import CSV, only when every journal balances.
- One folder that opens in your browser with no internet. Your books stay on your computer.
Questions
Which columns does QuickBooks need?
Intuit's import steps say the file should include Journal No., Journal Date, Account Name, Journal/Description, Debits and Credits. This tool reads those columns, and also accepts Debit, Credit, Date, Account and Description as header names.
Why can't I download until it balances?
A journal with unequal debits and credits cannot be a sound journal entry, so the import file is not written until each one balances to the cent. Amounts must have at most two decimals.
Why did a name get an apostrophe?
Text in Journal No., Account Name or Description that starts with = + - or @ is written with a leading apostrophe, so a spreadsheet does not run it as a formula. Edit it in QuickBooks if you need the exact text.
What about sub-accounts?
Intuit says journal lines must use a parent account, and a sub-account needs the parent name and sub-account name separated by a colon, like "Parent account: Sub Account". Account names are copied as you write them, except for the leading apostrophe described below.
What about Accounts Receivable and Accounts Payable lines?
Intuit says those lines need a Name. This file has no Name column, so the tool warns you when it sees such an account.
What counts as a repeated line?
The same journal, date, account, description and amount. Repeats are kept, and the downloads wait until you tick the box.