QuickBooks Online uses a concept called 'Source' and 'Targets' to build transactions and reports. Understanding this concept will help you create more effective reports and faster advanced finds.
The Source of a transaction is the summary information about the transaction and includes the source account, source name, source memo, source amount, etc. Each element of source data occurs only once in the transactions.
The Targets of a transaction provides detailed information about the transaction and includes the target accounts, target names, target memos, target amounts, etc. Some characteristics of the Targets are:
Filters allow Source and Target data into a report to show the information that you need.
Embedded filters are part of the report programming. They cannot be changed when you customise reports.
Default Filters are set when you first run a report, they can be changed when you customise reports.
Filtering for A/R or A/P on cash basis removes all data
The report is blank because Accounts Receivable (A/R) and Accounts Payable (A/P) are accrual accounts; you cannot report on them on a cash basis.
The Profit and Loss Standard displays target data from invoices and bills and source data from:
The Balance Sheet Standard displays source data and some target data from:
The Statement of Cash Flows displays both source and target data:
The General Ledger displays both source data and target data because it draws on all of the data in the company file.
A/R Ageing Summary, Customer Balance Summary/Detail, Invoice List Report. These reports displays:
A/P Ageing Summary, Supplier Balance Summary/Detail, Unpaid Bills Report. These reports displays: