1.Post revenue and expense account balances to final general ledger accounts

2.Enter gross and net profits for reporting period in the general ledger

GENERAL LEDGER - EXAMPLE 2

A general ledger used to create a budget for multiple accounts and compare your actual expenses with planned expenses; it calculates totals for you.

YEAR: Actual versus Budget YTD

Account Number

Account

YTD Actual

YTD Budget

Remaining Budget $

Remaining Budget %

1000

Office

$425.00

$50,000.00

$49,575.00

99.15%

2000

Store

$905.27

$75,000.00

$74,094.73

98.79%

3000

Staffing

$17,500.00

$ 100,000.00

$82,500.00

82.50%

4000

Equipment

$1,854.00

$25,000.00

$23,146.00

92.58%

5000

Other

$35.60

$50,000.00

$49,964.40

99.93%

Total

$ 300,000.00

$279,280.13

93.09%

CUSTOMER LEDGER

A template used to record all the orders placed by a given customer. After you have created a template for each customer, you will have the beginnings of a customer order data base. This template contains no calculations.

Customer Ledger

NAME

CUSTOMER PHONE

ADDRESS

CUSTOMER EM

CITY

STATE

PURCHASING MGR

P/C

PURCHASE

SALES

DATE

ORDER #

ORDER #

DATE

ACCT #

QTY

DESCRIPTION

PART #

VIA

SHIPPED

BILLED

JJ0099

CCH0099

X 2014

OA0766

600

XYZ Tools

JR1101

FEDEX

date

date