Post and send to QuickBooks
Turn coded bank lines into QuickBooks expenses, with a review step in between.
Getting a bank line into QuickBooks takes two steps. You get a chance to check everything before QuickBooks is changed:
- Post lines in Bank transactions. They move to Expense transactions, still only in Databookly.
- Send to QuickBooks from Expense transactions. This creates the expenses in QuickBooks.
Money spent only, for now
Posting works for Spent lines, which become Expenses. Handle Received lines (deposits) in QuickBooks for now.
1. Post from Bank transactions
Each line needs a supplier, a category, or both. A complete line has both. Use the Transactions filter to show Complete (supplier + category) or Incomplete (one missing) lines.
- Post on a row posts that line.
- Post selected posts the lines you've ticked.
- Post complete posts every Spent line that has both a supplier and a category.
If a line is missing one of the two, Databookly asks you to confirm first. A line with no supplier becomes an expense with no payee. A line with no category goes to Uncategorized Expense, as QuickBooks does. You can still fix both on Expense transactions.
2. Send to QuickBooks
Open Expense transactions. Posted lines are listed first, under Posted from Bank transactions, with their Payee, Category and Bank account.
- Fix the payee or category inline if needed.
- Changed your mind? Back to Pending returns the line to Bank transactions.
- Click Send to QuickBooks. Databookly creates each expense in QuickBooks and refreshes the list.
If QuickBooks rejects a line, its reason shows under the line. Fix it and send again.
3. Match in QuickBooks Banking
The original line is still waiting in QuickBooks' bank feed. In QuickBooks Banking → Pending, QuickBooks suggests the expense Databookly created as a match.
Use Match, not Add
Confirm each line with Match. Clicking Add would record the same transaction a second time.