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
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: email@example.com
Tammac Consultants cc P O Box 173 Ixopo 3276 Tel 039-834-1405