Extracting Accounting Info

You will sometimes need a list of certain items from one of your Ledgers or Logbooks. For example, for time and materials billing, you may want to get a list of all labor and material items for a particular job.

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. Goldenseal does not require Excel.

To extract a list of items from the MacNail construction accounting software, type the desired criteria into the Query Box, then choose *Extract Special from the DATA menu.

A separate file will be created, listing all items matching the current criteria. It will be named Material Extract if it came from a Material Log, or Labor Extract if it came from a Labor Log, etcetera.

If you have checked Include date in report file names? under *MacNail Options, the file name will also include today 's date.

You can re-format the new file for printing or for export to a word processor or other program.