Sage

$300$

$$ERP

$2018$

$$General Ledger

PRACTICAL EXAM ANSWERS

$$Load the dataset CCLSYS

$.$

DCT into the database CCLSYS and the dataset CCLLTD

$.$

DCT into the database CCLLTD from the SG

$30018$

E

$1$

$$Lab Data Practical Exam folder from the desktop using the Database Load utility.

Start Sage

$300$

$,$

$$and then open Collegiate Computer Limited with a session date of

$01/15/2017$

$.$

The company has purchased a new computer. Enter and post the following journal entry:

Batch Description: Office Improvements

Entry Description: New Computer for Office

Account: Office Equipment

Debit:

$2000$

Account: Bank Operating Loan

Credit:

$2000$

$.$

Print the Posting Journal to your local printer.

Set your print destination to Preview.

Use the Snipping Tool

$($

Window Snip

$)$

$$to take a screen capture of the Posting Journal. From the Snipping Tool, click Copy and Paste the screen capture in your data file under

$1$

$.$

$$Posting Journal

$-$

$$Step

$5$

Note: If you are running this lab on a small monitor, complete the following steps in the lab environment before taking the screenshots:

$1)$

$$Set the window display to full

$-$

screen mode

$2)$

$$Unpin the task bars

$3)$

$$Reduce the size of the report

Print the Trial Balance to your local printer.

Use the Snipping Tool

$($

Window Snip

$)$

$$to take a screen capture of the Trial Balance. From the Snipping Tool, click Copy and Paste the screen capture in your data file under

$2$

$.$

$$Trial Balance

$-$

$$Step

$7$

Add Internet Expense

$(6045)$

$$accounts for the Service and Product departments.

Print the Chart of Accounts report to your local printer.

Use the Snipping Tool

$($

Window Snip

$)$

$$to take a screen capture of the Chart of Accounts report. From the Snipping Tool, click Copy and Paste the screen capture in your data file under

$3$

$.$

$$Chart of Accounts

$-$

$$Step

$10$

Create a budget for the Office Equipment account based on the following:

Budget Method: Base

Percent Increase

Base Amount:

$10$

$,$

$000\mathrm{.}00$

Increase:

$3\mathrm{.}00000$

$.$

Type the Budget

$12017$

$$amount for Period

$3$

$$and Period

$12$

$$on the data file under

$4$

$.$

$$Budget

$-$

$$Step

$12$

$.$

Display the Fiscal Set Comparison for the Office Equipment account and then make the following selections:

Amounts: Net Change

Fiscal Set

$1$

: Actuals

Year

$1$

:

$2017$

Fiscal Set

$2$

: Budget

$1$

Year

$2$

:

$2017$

$.$

Type the Difference amount for Period

$1$

$$on the the data file under

$5$

$.$

$$Fiscal Set Comparison

$-$

$$Step

Create the schedule code FIRST based on the following:

Description: First Day of the Month

User Mode: All Users

Remind in Advance:

$5$

$$days

Schedule Start Date:

$01/15/2017$

Recurring Periods: Monthly

Frequency: Every

$1$

$$Month On the

$1$

st day.

Add a recurring entry based on the following information:

Recurring Entry Code: PREPAID

Entry Description: Prepaid Interest Expenses

Schedule Code: FIRST

Start Date:

$01/15/2017$

Expiration Type: No Expiration Date

Account:

$7010$

Debit:

$10\mathrm{.}25$

Account:

$1500$

Credit:

$10\mathrm{.}25$

$.$

Create a recurring entries batch based on the following:

Run Date:

$02/01/2017$

From Recurring Entry Code: PREPAID

To Recurring Entry Code: PREPAID

Method: Create a New Batch

Print the Batch Listing for batch

$000002$

$.$

$$Take a screen capture of the Batch Listing using the Snipping Tool, click Copy and Paste the screen capture in your data file under

$6$

$.$

$$Batch Listing

$-$

$$Step

$18$

Post batch

$00002$

$$and then print the Trial Balance for Year

$/$

Period

$2017/02$

$$your local Printer.

Take a screen capture of the Trial Balance using the Snipping Tool, click Copy and Paste the screen capture in your data file under

$7$

$.$

$$Trial Balance

$201702$

$$Step

$20$

Print both pages of the Balance Sheet using quikbal

$1$

$.$

xls for the Year

$/$

Period

$2017$

$-$

$02$

$$to your local printer.

Take a screen capture of the Balance Sheet using the Snipping Tool, click Copy and Paste the screen capture in your data file under

$8$

$.$

$$Balance Sheet

$$

$$Step

$22$

Check Data Integrity of the General Ledger and type the number of errors in your data file under

$9$

$.$

$$Data Integrity

$-$

$$Step

$23$

Create the year

$2018$

$$in the Fiscal Calendar and then Create a New Year.

Display the Journal Entry for the Batch

$000003$

$.$

$$Type the Source Code and then Debit account number used on the data file under

$10$

$.$

$$Journal Entry

$-$

$$Step

$25$

$.$

Preform Period End Maintenance, by select

$1$

$.$

$$Posting Journal

$$

$$Step

$5$

Insert the screen capture your Posting Journal.

$2$

$.$

$$ Trial Balance

$$

$$Step

$7$

Insert the screen capture of your Trial Balance.

$3$

$.$

$$Chart of Accounts

$$

$$Step

$10$

Insert the screen capture of your Chart of Accounts.

$4$

$.$

$$Budget

$$

$$Step

$12$

The Budget

$12017$

$$amount for Period

$3$

$$is

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$.$

The Budget

$12017$

$$amount for Period

$12$

$$is

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$.$

$5$

$.$

$$Fiscal Set Comparison

$$

$$Step

$14$

The Difference amount for Period

$1$

$$is

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$\_$

$.$

$6$

$.$

$$Batch Listing

$$

$$Step

$18$

Insert the screen capture of your Batch Listing

$7$

$.$

$$Trial Balance

$201702$

$$Step

$20$

Insert the screen c