ExcelPayroll Service 1

Free Download
Excel Accounting Program for Everyone

Video Instructions (Select a topic below to watch in YouTube)

General Ledger:

1	General Setup
2	Add a general ledger account
3	Edit a general ledger account
4	Delete a general ledger account
5	Edit a reporting title
6	Print the Chart of the GL Accounts
7	Enter a journal entry
8	Auto Reversal journal entry
9	Setup a recurring journal entry
10	View a general ledger
11	View general journal
12	Financial Statements
13	Income statement reporting group detail
14	Balance sheet reporting group detail
15	Post journal from subsidiary ledgers
16	Handle accounts errors
17	Handle errors from subsidiary journals
18	Month-End and Year-End Closing
19	Link AP and AR modules
20	Program Renewal and Updates
21	Remove/Delete Older year history
22	Use Data Files and File Management

Accounts Payable:

1	Accounts Payable Setup
2	Edit or Design Check Layout and formats
3	Add a vendor
4	Edit a vendor
5	Delete a vendor
6	Enter an AP invoice or Memo from a vendor
7	Recurring Payable invoice templates
8	Enter a Purchase Order
9	Convert PO to an AP invoice
10	Print checks to pay open invoices
11	Cut a COD check
12	Manual checks or payment via ACH or other payment
13	Reprint a printed check
14	View a vendor ledger
15	Apply open credits to invoices or debit memos
16	Un-apply credits previously applied to invoices
17	Analyze an AP Item
18	View AP invoice journal
19	Void an AP Check or Payment
20	Void an AP invoice
21	AP Aging Report
22	Print 1099 and 1096 forms
23	AP all other Reports
24	Release AP journals to general ledger
25	Month-End and Year-End Closing
26	Remove/Delete Older year history

Accounts Receivable:

1	Accounts Receivable Setup
2	Sale Rep and Commission Setup
3	Edit or Design invoice printing format
4	Add a customer
5	Edit a customer
6	Delete a customer
7	Add an inventory item
8	Edit an inventory item
9	Delete an inventory item
10	Enter a sales invoice and Credit memo
11	Recurring Sales Templates
12	Enter a sales order
13	Ship a Sales order and convert to a sales invoice
14	AR Cash Receipt from a customer
15	Non-AR Cash receipt from other sources
16	Handle bounced checks from customers
17	View a Customer ledger
18	Analyze an AR item
19	View-Reprint Invoice
20	View Invoice Journal
21	Void an Invoice
22	Apply open credits to invoices or debit memos
23	Un-apply previously applied credits( to invoices)
24	Receiving an inventory item from vendor
25	Receiving inventory in batch from a PO
26	Inventory Physical Count and Adjustments
27	Inventory reports
28	Inventory evaluation Reports
29	Sales forecasting Reports
30	AR and Sales Reports
31	Commission Reports
32	Sales Tax Reports
33	Distribution Reports
34	Other Sales Analysis Reports
35	Release AR journals to general ledger
36	Month-End and Year-End Closing
37	AR Renewal and Updates
38	Remove/Delete Older year history

Purchase Order:

1	Enter a purchase order
2	Delete a purchase order
3	Change a purchase order
4	Convert purchase order to AP invoice
5	Purge purchase orders
6	Reprint a purchase order
7	Purchase order reports

Sales Order:

1	Enter a sales order
2	Delete a sales order
3	Change a sales order
4	Ship order or convert Sales order to invoice
5	Purge sales order
6	Reprint sales order
7	Sales order reports

Payroll:

1	PR general setup
2	Tax withholding setup
3	Import tax rate (auto setup)
4	Voluntary withholding setup
5	Design your check formats
6	Add an employee
7	Delete an employee
8	Edit an employee
9	Make payroll to an employee
10	Make payroll to a batch employees
11	Re-print a payroll check
12	Void a payroll check
13	Print payroll record
14	Print payroll register
15	Tax liability report
16	Print W2 forms
17	Print W3, 941 tax information
18	Release payroll entries to GL
19	Close a payroll year
20	Payroll update and upgrade

Time Card:

Fixed Asset:

1	Enter an Asset Item
2	Edit an Asset Item
3	Delete an Asset Item
4	Record and Keep your Asset List
5	Produce an Amortization or Depreciation Schedule
6	Produce a depreciation for a month or a year
7	Reconcile your depreciation schedules