Etapa Experimental II:

This article applies to the Accounts Receivable Aging, Accounts Payable Aging, Open Client Deposit Report, Open Vendor Deposit Report, and the Work in Process Report.

The “Other Entries Affecting” amount in the totals section of the report is the amount of difference between the sum of the records on the report and the General Ledger Balance for the account. For example, if on the Aged Accounts Payable Report there is $100.00 in the totals section under “Other Entries,” then the Accounts Payable Account Balance for the respective period does not match the report by $100.00.

To track down this amount we are looking for transactions that were posted to the Accounts Payable Account (in our example) that normally do not show on the Accounts Payable Report. For Accounts Payable, the only entries that should be in this account are purchases and

payments (checks), any other type of entry, journal entries, client invoices, etc. are not acceptable and are most likely in this account due to an error or incorrect settings. For Accounts Receivable, the only entries that should be in the A/R account are client invoices, client invoice adjustments, and payments on the invoices.

To get a list of other entries, we can use the Account Inquiry Report under General Ledger Reports.

Using our example the report should be printed for the Account Payables Account (20000) and the Starting Fiscal Month should be rolled back to the earliest possible setting. The Ending Fiscal Month should be set to the same period that the report (A/P Aging in our example) was run for. Make sure that the report is printed to the preview window because it will be many pages long. The Account Inquiry will list all entries in the A/P account in type order. We are looking for types of transactions that do not start with the words “Purchase, Hand Check, or Computer Check.” The following shows good entries:

The sum (net debit/credit) of all entries that are not Purchase, Hand Checks, or Computer Checks should equal the “Other Entries” amount. These “bad” transactions should be listed at either the beginning or the end of the report. For example, Misc. Cash Receipts and Journal Entries

(especially if they do not sum to zero) should not be in our Accounts Payable Account. Check the first page of the report and skip to the last page to see if there are any entries such as these, the “bad” entries listed should be corrected to hit the correct account.

Index

A

Accounting Records - Finding ... 92

Accounts, G/L... 17

Accounts - Specifying... 18

Accounts Payable Overview ... 62

Accounts Receivable Overview ... 78

Acknowledgement – Showroom Orders ... 130

Adjust A Client Invoice ... 85

Adjust Account Balance ... 90

Adjusting Inventory... 98

Advanced Options - Project ... 27

Appointment Calendar ... 57

Auto Reverse JE ... 90

B

Bad Debt Write Off ... 85

Bank Service Charges ... 77

Bar Code Data Collection Window... 120

Bar Code Labels ... 121, 122, 124 Bar Code Lot Types ... 114

Bar Code Scanner - Protable ... 113

Budgets On Income Statement ... 17

C

Cash Receipts - Editing or Voiding ... 81

Cash Receipts - Miscellaneous... 80

Cash Receipts From Clients ... 78

Catalog System... 36 Chart Of Accounts... 17 Check Forms ... 13 Check Reconcilation ... 75 Checks - Computer ... 71 Checks - Payroll ... 93

Client Deposits - Receiving ... 78

Client Invoice Credits ... 85

Client Invoices ... 82, 85 Client Invoices - Adjusting... 85

Closing Month And Year ... 88

Closing The Year ... 16

COGS Accounts ... 18, 19 Company Information... 14

Company Information - Inventory Setup ... 96

Completed Items, Making ... 32, 43, 45 Copying Items ... 44

Creating Purchase Orders ... 48

Credit A Client Invoice... 85

Credit Cards To Pay Bills ... 72

Credit on Store Sales ... 111

D

Data Collection Window ... 120

Data Collector Setup ... 113

Definitions... 11

Delivery Tickets ... 55

Delivery Tickets – Showroom Orders ... 131

Deposit Ticket Forms ... 13

Deposits For Vendors ... 70

Deposits From Clients - Receiving... 78

E

Edit Journal Entry... 90

Edit Time Entries... 106

Editing Cash Receipts... 81

Editing Proposals ... 47

Editing Purchase Orders ... 50

Emailing POs ... 51

Employee Hours Entry ... 105

Employee Time - Overview ... 103

Employees - Setting UP ... 93

Employees Time Billing... 103

Enter PO Related Vendor Invoices ... 66

Entering Hours ... 105

Entering Operating Expenses ... 65

Entering Project Items... 32

Envelopes... 13

F

FAQ - Add/Remove an Item on a Proposal with a Deposit... 144

FAQ - Client Return - Project Related... 138

FAQ - Client Return for POS Purchase ... 139

FAQ - Convert to a Cash Basis... 134

FAQ - Find Other Entries Affecting This Account ... 148

FAQ - Month End Closing ... 143

FAQ - Print Payroll Checks ... 133

FAQ - Refund a Retainer ... 144

FAQ - Returned Item Transferred To Inventory ... 140

FAQ - Split Payment On POS ... 143

FAQ - Vendor Deposit Refund ... 135

FAQ - Vendor Invoice Refund ... 136

FAQ - Year End Closing... 143

Faxing POs ... 51

Finance Charges... 86, 87 Find An Entry ... 92

Fiscal Month ... 15

Fiscal Month Setting... 16

Forms ... 13

Frequently Asked Questions - Overview... 133

G

G/L Accounts... 17

General Journal Entry ... 90

General Ledger Overview ... 88

Gift Certificates & Store Credits ... 111

Groups... 36, 37, 38

H

How To - Add/Remove an Item on a Proposal with a Deposit... 144

How To - Client Return For Project... 138

How To - Client Return POS Purchase... 139

How To - Convert to a Cash Basis... 134

How To - Enter Vendor Invoice Refund ... 136

How To - Find Other Entries Affecting This Account ... 148

How To - Month End Closing ... 143

How To - Print Payroll Checks ... 133

How To - Process Manual Credits for Returned Inventory Items ... 140

How To - Refund a Retainer ... 144

How To - Returned Item Transferred To Inventory ... 140

How To - Split Payment On POS ... 143

How To - Year End Closing... 143

How To... ... 133

I

Important Definitions ... 11

Importing, SIF File... 59

Inactive Items, Making ... 32, 43, 45 Income Statement Budgets... 17

Installation - Before You Start ... 6

Installing On A LAN With Dedicated Server... 8

Installing On A Peer-To-Peer Network... 8

Installing on A Stand Alone Computer ... 7

Installing On A Terminal Server ... 9

Inventory Adjustments... 98, 100 Inventory in Project Specifications ... 40

Inventory Invoices from Vendor ... 66

Inventory Setup - Company Information ... 96

Inventory Status ... 100

Invoice Payments From Client ... 78

Invoicing – Showroom Orders... 132

Invoicing Clients ... 82

Item Specifications – Showroom... 129

Items for projects... 32

J

Journal Entries ... 90, 91

K

Keyboard Shortcuts... 11

L

Labels... 13

Lock Price Button ... 36

Lot Types... 114

M

Miscellaneous Project Expenses ... 68

Miscellaneous Receipts ... 80

Month End Closing... 88

N

New Stock Items ... 98

O

Opening Balances Overview... 21

Operating Expense entry ... 65

Order Tracking - PO Status... 54

Order Tracking Overview ... 53

P

Passwords... 15

Payee - Entering ... 62

Payments On Client Invoices ... 78

Payroll ... 93, 94, 95 Peer-To-Peer networks - Installation ... 8

Percon Portable Scanner ... 113

Percon PT 2000 Data Collector ... 116

Percon PT2000 Setup... 113 Phone Numbers ... 57 Pictures ... 38, 39 PO - Creating ... 48 PO - Editing ... 50 PO - Reprinting ... 50 PO emailing... 51 PO Faxing ... 51

PO for Stock Inventory ... 100

PO Status Window ... 54

Point Of Sale ... 107, 108 Point of Sale Invoiceing With The Scanner... 121

Portable Data Collector ... 113

Printing Bar Code Labels ... 121

Printing Checks ... 71

Printing Proposals ... 45

Project Invoices ... 82

Project Items ... 32

Project Overview ... 24

Project Setup - Advanced ... 27

Project Setup - Basic... 24

Project Specifications... 31

Proposal Editing and Reprinting ... 47

Proposal Printing... 46

PT-2000 Scanner ... 113

Purchasing For Stock Inventory ... 100

Q

Quantity Delivered vs Quantity Shipped ... 55

Quotes - Showroom ... 126

R

Receiving Client Deposits ... 78

Receiving Inventory... 102

Reconciling the Checkbook... 75

Reimburseable Expenses ... 68

Reprinting PO... 50

Reprinting Proposals... 47

Retail Sales ... 107

Retainers From Clients ... 78

Returned Stock Inventory... 111

Revenue Accounts ... 18

Rolodex® ... 57

S

Sales Accounts ... 18, 19 Sales Tax Codes... 20

Scanner Tips And Troubleshooting... 124

Scanning Bar codes ... 116

Setting Up A New Project... 24

Setting Up The Portable Data Collector... 113

Setting Up Vendors ... 62

Settings, SIF Import ... 59

Ship To Address... 25, 127 Shipped Quantity... 55

Short Cut Keys ... 11

Showroom System ... 125

SIF File Import... 59

Special Order Vendor Invoices ... 66

Specification Sheets... 41, 43 Specifications – Quotes and Orders ... 129

Specifications – Showroom... 129

Specifying - Overview ... 31

Specifying From Inventory ... 40

Stock Inventory Overview ... 96

Stock Inventory PO ... 100 Store Credits ... 111, 112

T

T-Accounts ... 89 Terminal Server... 9, 10 Terminology ... 11 Time Activities ... 103

Time Billing - Overview ... 103

Time Employees ... 103

Time Entry ... 105, 106 Time Entry Edit... 106

To Do List ... 56, 57 Tracking Orders - Overview ... 53

Transaction Search ... 92

Troubleshooting The Scanner... 124

U

Using Groups ... 38

Using Pictures ... 38

Using The Portable Data Collector ... 116

V

Vendor Deposits... 70

Vendor File ... 62

Vendor Invoices - Inventory ... 66

Vendor Invoices - Special Order ... 66

Vendor Translation, SIF ... 60

Void Journal Entry... 90

Voiding Cash Receipts... 81

W

Wire Transfers To Pay Bills... 74

Write Off Client Invoice ... 85

Y

Year End Closing ... 88

In document “SUSTITUCIÓN DE MARGARINA POR ACEITE DE AJONJOLÍ Y CREMA DE AJONJOLÍ (Sesamum indicum) EN LA ELABORACIÓN DE GALLETAS”. (página 54-63)