Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Chapter 13
Chapter 14
Chapter 15
Chapter 16
Chapter 17
Chapter 18
Chapter 19
Chapter 20
Chapter 21
Chapter 22
Chapter 23
Chapter 24
Chapter 25
Chapter 26
Chapter 27
Chapter 28

Chapter 14

Back to Previous Chapter

Forward to Next Chapter

Back to Contents


Advanced Search


Transaction Reports

The numbers on the profit and loss (and similar reports) summarize income and expense transactions.  This section is about reports that list transactions, including transfers between balance sheet accounts.

Transaction Reports list the amounts  XE "transaction reports" of the basic documents such as invoices, checks, bills.  Options are:

By Date listing the documents in that sequence.

By Customer filters on the basis of Name, including All Customers.

By Vendor filters on the basis of Name, including All Vendors.

Adding the amounts of invoices, bills, checks, etc. would not make sense, so these reports have no totals.

Transaction Detail Reports list  XE "transactions detail reports" the amount of the basic document, plus all of the opposing entries.  Options are:

By date listing all of the transactions in that sequence.

By Account with subtotals for each account.

The Amount column is effectively a Debit column.  All of the Credit entries appear as negative amounts.  The default filtering is All Accounts .  In this case, the debits equal the credits, and a total of zero appears at the bottom.

Customization of transaction reports is generally the same as for profit and loss reports,  with one major difference.  All amounts are in one column.  There are no progressive columns across the page for month, account, name, or the like. The report shown came up with some empty or redundant columns, which were quashed using the Customize button.

The Split column XE "split column:reports"  lists opposing accounts.  The word -SPLIT- indicates multiple opposing accounts.  It the illustration they happen to be the next two lines down. In other cases, they may be far down a long report.   The explanation can also be found by double-clicking on an amount and zooming to the source transaction document.  This is particularly useful on a Transaction (not detail) report.

Cash basis transaction XE "cash basis reporting"  reports can be chosen in customizing.  The default for transaction reports will always be accrual.   Cash basis transaction reports face an inherent problem . Transaction reports list transactions individually when they happen.    Cash method accounting means that income is recorded when money is received. 

Consider an invoice recording goods or services sold on account.  The income accounts are named in the items in the invoice, but income is not recorded at that time.  Later payment is received and applied to that invoice. For further complication, the invoice may have been paid in two installments.  QuickBooks cash basis reports show income in the accounts named in the items, as of the date of the payment.  A cash basis transaction report has conflicting requirements as to how to show this income.

Contents |   Up   |   Previous   |   Next

About BlockTax   |   Awards   |   Contacts   |   QB Newsletter   |   Home   |   Legal
Last modified: May 21, 2004