Problem
*Reconcile
Ledger not working-- just shows final balance, gives error message, or is otherwise
off
Diagnosis
1. make sure the 'blank' cells in statement col. are REALLY blank.
2. Make sure there is no single quote (') in the file name used
in MacNail construction accounting
software.
3. does the 'stmt.' title at the top match the title in Criteria?
4. ditto for check number title-- Criteria should match top of worksheet.
5. check for MacNail Accounting Mgr 3.4 dated before 3/93, used on a Quick Ledger.
6. Using Accounting Mgr 3.3b or earlier?
NOTE-- Goldenseal accounting software includes a nifty
Reconcile command that is much easier to use than MacNail's.
Solution
1. erase them
2. rename file
3. tidy up titles so they match
4. tidy up titles so they match
5. send latest Manager. Older version always says problem is at line 3, when it really may be anywhere.
6. try looking for "cash" in the ck no column-- if those items are being added/subtracted in run total column,
that will throw off the reconcile. See notes below
"cash" items should NOT add payouts/deposits in the 'running total' column.
Non-cash items MUST add payouts/deposits. These may be off if:
• they have changed run total formulas or names in check column.
• they have cut and pasted formulas in running total
• they did 'fix incorrect entry' on a cash item in version 3.3 or earlier (minor bug)
Also, if running total has erroneous
formula anywhere, that could screw it up. Try filling down in the running total col to restore the formulas, then
reconcile again.
NOTE: MacNail accounting software version 3.4 checks for
problems with "cash" or run
total formulas.
Comments
Entered 1/15/93 by Dennis. Updated 11/9/2010.
|
