Home
Contents
Legal
Dedicated
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
Glossary
Error
Messages

Earlier Versions

QuickBooks 4 and earlier had a different Filters XE "filters:QuickBooks 4 reports"  window, which is brought up in the same manner.

Source means the balance sheet account in whose register a given original or primary transaction is recorded.  (Income and expense accounts appear and may be selected, but such selections will not cause any transactions to be included in the report.) 

icon note

Some transactions appear in balance sheet accounts, but can prove elusive.  An example is a bill payment in Accounts Payable.  Selecting this account as the s ource would find the transaction.  The opposite end of this transfer is the bill payment check, in the checking account.  This is a secondary transaction.  Selecting the bank account as a source would not find the bill payment. The report routine will scan through the designated balance sheet accounts and consider for inclusion both ends of each transaction.  They will be included if the Accounts selection is All or includes the accounts involved.

Once the transaction is found in the source account, each end will be included or excluded depending on Account filtering.  Continuing the example, if accounts included the checking account, the check would be included.  If accounts did not include accounts payable, the bill would be left out.  The Source function is not used in QuickBooks 5 reports.

The other filtering functions work similarly to those of the same name in QuickBooks 5.

icon note

Special purpose reports XE "Special purpose reports"  XE "reports:special purpose"  sometimes prove difficult to develop, and the problem usually is too much data.  Reports may toggle between nothing and an avalanche.  The solution is to develop the report with a small, controlled group of transactions.  The choices are a separate company file set up for the purpose, or a few postdated transactions (sometime between the current date and 2027) in your real company. When you can systematically open or close a filter and include or exclude one or two transactions, you are getting a handle on the process.  Then expand the scope until you are getting the report you want.