Accpac 228 Pretest Final: I. General Ledger
Accpac 228 Pretest Final: I. General Ledger
Accpac 228 Pretest Final: I. General Ledger
Pretest final
I. GENERAL LEDGER
You are the accountant of Your name Tele Inc. Your company has decided to use Sage Accpac to
perform all accounting functions. Jan 1, 2017 is the beginning of its fiscal year.
The company uses a 12-period fiscal year and its Functional Currency is Canadian dollar.
Account Description
1100 Bank
1200 Accounts receivable
1260 Allowance for bad debts
1300 Inventory
1400 Office supplies
1500 Prepaid expense
2000 Accounts payable
2020 HST payable
2200 HST receivable
2220 Prepayment received
3000 Common stock
3200 Retained earnings
4000 Sales
4020 Sales discount & returns
4500 Interest income
5000 Purchase Discounts
6030 Write off account
6050 Bank/credit card charge
1. Setup the G/L options and print the GL Options report showing default account structure and
closing account
4. Create tax classes for both Sales and Purchases. Class 1 is Taxable and Class 2 is non-taxable.
5. Add Tax Groups “ONT” for sales and purchases. Use “calculate tax by detail” as the Tax
Calculation Method.
6. Add Bank Code “TD” with the following particulars:
TD
GL Account #: 1100,
Write off account #: 6030
Bank/credit card charge Account # 6050
7. Print the Tax Authority, Tax classes and tax rates reports for sales and purchases
Set an Interest Profile Code “COM” with the description “2% for AR accounts” and annual interest rate
of 2%. 5 DAYS
On January 30, 2017 Beckford Inc. pays by cheque No. 1085 for $1525.50. Apply the receipt to
invoice BD2017.
15. Customer aged trial balance by due date as of January 31, 2017 show applied details
16. Customer statement as at January 31, 2017 for Beckford showing applied details of paid
transactions
Bank TD
Check stock code CHAD
Description Check and Advice forms
Next cheque number 5055
Stock type Combined check and advice
Cheque form APCHK01.RPT
Add Account Set “ACCAP” with the description “All Accounts Payable”, include the following
accounts:
Payable control account #2000;
Purchase discounts account - #5000;
Prepayment account #1500.
Add the Payment Selection Code – MTHLY for all due invoices.
On January 10, 2017 bought supplies inventory for $3,000.00 plus taxes from CATCH22 Inc.
CATCH22 invoice # B1220 dated January 11, 2017. On January 12, 2017 you perform a cheque run
to pay this invoice. DUE ON OR BEFORE JAN 30 OR TAKING DISCOUNTS JAN 12 TO 22
BATCH DATE: JAN 12, 2017 PAYMENT DATE JAN 12
Process the above transactions and print the following reports:
21. Aged payables report as at January 31, 2017 with applied details and fully paid transactions
IV GENERAL LEDGER
Process the Accounts Receivable and Accounts Payable sub-ledger batches in G/L. Use one posting
sequence and print the following:
-End of Paper-