If the MacNail construction
accounting software reports a statement balance that is equal to the actual bank statement, your
job is finished.
NOTE-- In 2000, MacNail was replaced
by Goldenseal construction
accounting software. Goldenseal is an integrated program
that includes general accounting, job costing, payroll
and project billing, plus estimating and other features.
Its reconcile command is better than MacNail's.
If it disagrees, try the following procedure. We've had trying moments ourselves, but
this procedure has always worked eventually!
*
First make sure that you have entered and checked off all checks, service charges, interest, and deposits.
*
If that doesn't catch the error, compute the difference between the actual statement balance, and the 'theoretical' balance
as told by *Reconcile Ledger. checkbook, errorsledger, errorsledger, reconciling
*
If the difference is equal to plus or minus $10.00, $1, $.10 or $.01, you almost surely have a typographical
error in one digit of one item.
*
If the difference is equal to $20.00, $11, $9, $10.01, $.90, etcetera, you probably have two typographical
errors.
*
If the difference is an odd amount of just one digit (e.g. $.60) it is probably still a one-digit typo. You
may have misread a 1 for a 7, or a 4 for a 9.
*
If the difference is a completely odd amount (e.g. $7.49) look for a deposit or payout of exactly that amount
on both the Ledger and the statement. You may have forgotten to enter or check off one item, you may have switched
two digits, or you may have accidentally checked off something not on the statement.
*
Make sure you didn't accidentally enter an item twice, or enter a deposit as a payout (or vice versa).
Page 76 Accounting
*
If none of the previous items work, type the text you used as a check-off code into the stmt. column of the
criteria in the Query Box (see page 94). It will show you the total number of deposits and payouts that were checked
off, plus the total dollar value of each. Match these counts and totals against the items listed on your statement.
*
If the total number of items does not match, you may have forgotten an item (or checked off a wrong item).
Be warned that split payments can throw off the total item count, however.
*
If the total number of items matches but the totals do not match, you probably have a typo (or some combination
of errors).
*
You can use *Extract Special, from the DATA menu, to extract a list of all items that were checked off for
the statement. Scan them, and compare them to the statement.
*
You may need to use Excel's =sum() formula to check the totals on your extraction.
*
If still baffled, take a day or two as a breather. Then go through and re-check each item, changing the old
check-off text to something different.
|
