Back

Enter journal entries into QuickBooks Online

Balanced journal entries posted in QuickBooks from a payroll report or sheet, with a log

OpsEAs
Prompt

Open my source for this period's journal entries [source, e.g. a payroll report PDF in Gmail, a Google Sheet, or a payroll provider export] and build the entries for [period, e.g. last month or this pay run]. Map each line to my accounts using [account mapping, e.g. a mapping tab in the sheet, or how last month's entries were coded]. Use [entry date rule, e.g. the last day of the month] and a memo like [memo format, e.g. Payroll 03/15]. Before saving, check each entry: debits equal credits, every account exists, totals match the source. If anything doesn't balance, an account is missing, or an entry with the same date and memo already exists, skip it and ask me. Then enter up to [number, e.g. 20] entries in QuickBooks Online. Stop at any warning or error. Don't create accounts, pay anything, or reconcile. Send me a table: date, memo, account, debit, credit, status, plus anything skipped and why.

Works withqbo.intuit.com