QuickBooks 4 and earlier had a different
Filters XE "filters:QuickBooks 4 reports" window, which is brought up in the same manner.
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.)
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
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
account, each end will be included or excluded depending on
filtering. Continuing the example, if
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.
Special purpose reports XE "Special purpose reports" XE "reports:special purpose"
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.