Various Links on this Web Site: HOME | ABOUT US | OUR PURPOSE | SITEMAP | COMPUTER FUND ACCTG | HELPS | GLOSSARY
Ministries FROM: Jim
Bramer, Retired CPA-Auditor
RE: QB Integrity Report Proof Worksheets Originated: August 2000
The QB Integrity Report Proof Worksheets process below is within the context of the following:
--- There is a need to regularly produce QB memorized reports and then proof their integrity.
--- Go to 0622 to grasp use of QB Equity accounts to do Fund Accounting
--- Go to 0659 to be sure and begin your fiscal year properly.
--- The usual QB memorized reports in this effort are:
Integrity Report 01 - Photo - Please click here for more rationale in identifying the usual Balance Sheet as the financial status of a Ministry as a "Point in Time" Photo.
Integrity Report 02 - Video -- Please click here for more explanation of "Video" term as it's emphasis is transactions during a "Period of Time.".
Integrity Report 03 - SPF Class Report -- this report by QB Class answers the question of why each SPFund changes. This begins with the SPFund balances the first of the fiscal year - see 0659 -- and ultimately proves back to the QB Equity total of Report 04 below. Like Report 04, it is necessary to select each SPF Equity Account appearing within the Chart of Accounts. This exact steps in this Integrity Report 03 process is found at 0079 .
IntegrityReport 04 - List of Special Purpose Funds (SPFunds) - it is necessary to select each SPF Equity Account appearing in the Chart of Accounts.
If Reports 03 and 04 do not agree, you likely failed to include a class when posting, or you may not have clicked off the new SPF Equity Accounts for Report 03 in the filter selection above.
--- Samples of the above reports are found by viewing content of 0779.
--- The following Proof Worksheet provides some structure to efficiently accomplish this proof process. Some QB users place these numbers in a Excel worksheet and use such formulas to automatically do the math. Others QB users simply place the structure on their manual worksheet and accomplish the same thing.
--- Some systems need more than the four proofs mentioned here, and they adjust their worksheet accordingly.
A N N U A L P R O O F W O R K S H E E T
GPF Amounts From:
SPF Amounts From:
Let us know if you have any questions.
Please Click here for more topics having to do with the use of "QuickBooks and Ministry Fund Accounting" on www.bcidot.org. The bulk of this Publication originated in August 2000 and as UPTD: June 04, 2010
HOME | ABOUT US | OUR PURPOSE | SITEMAP | COMPUTER FUND ACCTG | HELPS | GLOSSARY