Accounting Tech Answers

The section contains answers to problems with the MacNail construction accounting software. This information comes from our Tech Answers database, which our support staff has used for tech support over the past 15 years.

NOTE-- MacNail is now retired, but we keep this help info on our website as a courtesy to people who still use our older software. Our newer Goldenseal accounting software is much better!

Links to other MacNail software answers-- General MacNail | Estimating | Job Costing | Payroll | Scheduling | Customizing | Spec Writer | General Computer Help

For general Excel, Macintosh and Windows help, click here.

Accounting Basics
Accounting Functions included
Accounts Payable Report

AIA Forms
Bounced Checks
Chart of Accounts
Credit Card and Loan payments
Customer Billing (A/R)
Discounts for Early Payment
Inventory (more)
Loans and Credit Cards
Petty Cash (more)
Purchase Orders (more)
Retainage
Sales Tax
Time & Material Billing
Trial Balance
Worker's Comp for Subcontractors

Accounting Menus and Commands
Menu Command doesn't work
Missing Commands, XL8 and Newer (more)
Query command is missing
Show Query Windows gives Macro Error (Windows)
Update Addresses misses some items

Accounting Worksheets
Damaged accounting worksheet
Deposits on first ledger line
Ledgers or Logs don't show pennies
Master Address bad number sequence
Master Address not updating
Master Index can't delete rows
Master Index can't add rows
Master Index- making a new one
Master Index missing numbers
Master Index- Project Numbering hints
Misc Log won't open from keyboard shortcut
Showing the Year in Dates
Splitting payout on first line
Viewing Unpaid items in Logs

Error Messages
Bad value line 3 when reconciling
Did not encounter Return or Halt
File must be converted to 3.0
Macro Error- C12, F104 when opening manager
Macro Error- E233 when document activates
Macro Error- E237 or D218 when adding rows
Macro Error- E300 or G328 when adding rows or posting
Macro Error- E316 when making report
Macro Error- F129 when choosing Ledger Item
Macro Error- H221 when updating addresses
Macro Error- H298 when making report
No checks could be printed from this selection
No matching items (more)
Sample File could not be found
Trouble with Extraction

Type 11 Errors (Macintosh XL5)
Unknown Error when reconciling

File Management
Excel 5 won't open file (Macintosh)
Removing 'always protect'

Lookups & Queries
Date Ranges
Getting Category AA as well as A
Job name shows #N/A
Job lookups are wrong
Lookups are wrong on items 41+
Numbers not names in Who column
Query won't work (more)
Special Query searches (blanks)
Weird stuff or #NAME in jobsite or name columns

Number Problems
Labor Log has zero cost
Material Log has zero cost
Material or Labor costs are waaay off

Posting Problems
Misc Log won't post (Windows)
Post to Ledger fills over void items
Post to Ledger is incorrect
Reconcile not working
Wants to post from ledgers to logs

Printing
Addresses not printing
Blank Pages
Can't print check to employee
Check printing is misaligned
Comments on checks
Customizing check print layout
Dot Matrix printers- alignment (more)
Dot Matrix printers- extra page feed
Prints same check over and over
Won't print checks (Windows only)
Wrong address when check printing (more, still more)
Wrong date on printed checks

Reports
Doubled or extra items in report
Financial report-- numbers don't match job costs
Incorrect or missing names in report
Labor Hours don't match in labor report
Not finding subcontractor report files (Windows)
1099 Report- can't find items
1099 Report- cutoffs
1099 Report- excluding some subs

Unusual Problems
Manager doesn't remember main files
Revision Log 3/96