QB Report Proof Worksheet     0610-07    ZZqbb

                                         - - - Rejoice in the Lord always ... again I say Rejoice !!! - - -

Various Links on this Web Site:      HOME  |  ABOUT  US   |    OUR PURPOSE   |   SITEMAP   |  COMPUTER FUND ACCTG  |  HELPS  |  GLOSSARY


                           TO:  Interested Ministries                                                                                  FROM: Jim Bramer, Retired CPA-Auditor
                                                                                                                                                            FILE:  0610-07/qbb   

                           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 belowLike 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 

As Of:

   GPF Amounts From:

     SPF Amounts From:

Date

01-Photo

02-Video

03-SPF List

04-SPFClass

Variance

4/1/2000

$ 11,775.02

        n/a

$ 11,775.02

$ 11,775.02

0.00 -

4/30/2000

$ 17,361.39

$ 3,452.37

$ 13,909.02

$ 13,909.02

0.00 -

5/31/2000

$ 13,823.36

$(1,495.06)

$ 15,318.42

$ 15,318.42

$0.00 -

6/30/2000

$ 10,405.47

$(5,467.33)

$ 15,872.80

$ 15,872.80

$0.00 -

7/3/2000

$ 12,928.91

$(3,694.76)

$ 16,623.67

$ 16,623.67

$0.00 -

7/10/2000

$ 16,630.22

$ (366.63)

$ 16,996.85

$ 16,996.85

$0.00-

7/17/2000

$ 19,509.86

$ 1,440.23

$ 18,069.63

$ 18,069.63

$0.00- 

7/24/2000

$ 15,997.51

$(1,498.76)

$ 17,496.27

$ 17,496.27

$0.00-

7/31/2000

$ 12,855.40

$(5,002.49)

$ 17,857.89

$ 17,857.89

$0.00-

8/7/2000

$ 17,096.02

$(1,545.09)

$ 18,641.11

$ 18,641.11

$0.00-

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