Invoices
Opens Export Invoices. Filters: Start Date / End Date (up to 365 days), Status — Open Invoices (draft, sent, late), Closed Invoices (paid, written-off) or All Invoices — and Filter Date By: Issue Date, Due Date, Payment Date or View Date (when the client first opened the invoice).
One row per invoice: Invoice ID, P.O Number, Client, Client Zip Code, Subject, Status, Issue Date, Due Date, Paid On, Paid Amount, Sub Amount, Discount, Tax 1 Amount (the amount taxed at tax 1), Tax1 Total, Tax 2 Amount, Tax2 Total, Total Amount, Balance, Tax Mode, Notes, Tags, View Date, Is Recurring.
Invoices Detailed
Opens Export Invoices Detailed. Filters: Start Date / End Date (up to 90 days, by issue date) and Invoice Status (Open / Closed / All). One row per line item: Invoice ID, P.O Number, Client, Client Zip Code, Subject, Status, Issue Date, Due Date, Paid On Date, Catalog Item, Item Type, Description, Quantity, Unit Price, Currency, Tax 1 Amount, Tax 2 Amount, Discount Amount, Line Item Amount. Use this one when you need to analyze what was sold rather than invoice totals.
Invoice Payment
Opens Export Invoice Payments: choose the Start Date / End Date of the payment dates (up to 180 days). One row per payment: Client Name, Payment Date, Payment Amount, Payment Fee, Payment Notes, Invoice Ref ID, Invoice Amount, Invoice Balance, Invoice Tags.
Invoice Templates
Downloads immediately. All recurring invoice templates in the import layout (see 18.8) plus Last Execution Date, Next Execution Date, Subtotal, Tax Total and Total.
QBO/PSS Balance Diffs
Downloads immediately, and only works when QuickBooks Online is connected (otherwise you see Please connect to QBO first!). It compares every open PSS invoice (draft, sent, late) with its QuickBooks counterpart: PSS Inv Ref ID, QBO Inv Ref ID, PSS Client, Issue Date, Due Date, Status, PSS Total Amount, QBO Total Amount, PSS Balance, QBO Balance, Error. Use it to find invoices whose balances have drifted apart before you reconcile (Section 4).