GUIDELINES FOR PREPARING TRIAL BALANCE FILE FOR TAMMAC FROM PASTEL

 

To prepare a trial balance report from Pastel for input into Tammac Financial Management programs, proceed as follows:

From the main window choose: View, General Ledger, Financial Reports, Trial Balance.

The following settings are required in the option box presented:

PRINT TO:  Choose “Spreadsheet, comma delimited” if using Pastel 5 and “Excel” if using Pastel 6

USE SUB ACCOUNTS:  Check this box

PRINT ZERO ITEMS:  Check this box

THIS YEAR:  Check this box

PERIOD START:  Choose the first of the month required

PERIOD END:  Choose the last of the month required

SHOW WHICH COMPARATIVE:  Choose “Last Year”

INCLUDE OPENING BALANCES:  Do NOT check this box

PRINT BALANCE SHEET ACCOUNTS FIRST:  Do NOT check this box

Choose OK. 

Pastel 5:  Give the file just created a convenient name with a “.txt” extension and specify the location to save the file. 

Pastel 6: An Excel spreadsheet will open with the just-created file visible.  Save this workbook to a convenient location, giving it a convenient name with an “.xls” extension.

Email the file to: tammac@xsinet.co.za

 

Tammac Consultants cc  P O Box 173  Ixopo  3276  Tel 039-834-1405

April 2003