GL – Examples for ACCRUED based setup.
Purchase Order Setup
Location: 1 LOC 1
1. Purchase Order Comments :
2. Transfer Vendor :
3. Suppress Cost Print on Tr :
4. Percent Standard Pack : 00
5. Auto Round During PO : N
6. Reset OL & SL if Sold=0 :
7. Round Value on Qty Avail : 0.50
8. Summarize Case-Lot : Y
9. Warehouse Location :
10. Suppress Cost Pr on Pick :
11. Ignore Case Lot on Tr. :
12. Ignore Standard Pack :
13. Use Curr Src on Transfers :
14. PO Print Program Name : PO.PRINT
Receiving Setup
1. Uninvoiced Receiving Account : Liability (ex. 2100 Uninvoiced Receiving)
2. Hold Backordered Items : N
3. Update Vendor Costs : Y
4. Update General Ledger : N
5. Update Accounts Payable : N
6. Inventory Account : Assest (ex. 1040 Inventory)
7. Freight Account :
8. Other Charges 1 Account :
9. Other Charges 2 Account :
10. Edit voucher when posting : N
11. Factor Freight into Cost : Y
12. Prevent Update to WH Cost : N
13. Prevent Update to Sales Hist : N
14. Cost Variance Account :
15. Last Receiving Cost Price Cd :
Accounts Payable Setup
1. Current Period ................. : 05/08
Account Payable Accounts
2. Accounts Payable Account ... : Liability
3. Discount Account ............ : Revenue (Typically, but can be setup as a contra-expense)
4. AP Variance Acct ............ : Expense
5. Multiple Acct Payable Accts .... : N
6. Create Detail from AP to GL..... : Y
7. Show Payroll Amounts in AP.....: N
8. 1099 Minimum Compensation Amt... : 600.00
9. AP Variance Maximum Percentage.. : 10.00
10. AP Variance Maximum Amount...... : 100.00
11. Dated Payable Sequence Flag..... : Y
AR Setup
Location: 1 LOC 1
1. Current Period : 05/08
2. Accounts Receivable : Asset
3. Cash : Asset
4. Payment Discount : Revenue (Typically, but can be setup as an expense)
5. Taxable Sales : Revenue
6. Non-Taxable Sales : Revenue
7. Cost of Goods : Expense
8. Inventory : Asset
9. Credit Returns Inventory : Asset
10. Warranty Returns Inv. : Asset
11. Sales Tax : Liability
12. Freight : Expense
13. Restocking Fee : Revenue
14. In Store Use : Expense
15. Service Charge : Revenue
16. Consignment Inventory :
17. Post Detail on Adjustments : Y
18. Print Cash Apply Report : N
19. Post Last Buy Date Option : B
General Ledger Setup
1. Current Period ................... : 05/08
2. Fiscal Starting Month ............ : 1 Jan
Fiscal Starting Mo. Sales Anal.... : 1 Jan
Interlocation Accounts
3. Main Location ................. : 1 LOC 1
4. Account Prefix ................ : 23
Summary Accounts
5. Balance Sheet P&L Account...... : 3999 Profit or <Loss>
6. Income Statement P&L Account... : 9999 Profit or <Loss>
7. Years ............................ : 05
04
8. Supress Auto Inter Loc Prompt..... : Y
Inventory Setup
These items are used in Inventory Maintenance and Indexing.
DO NOT CHANGE these setups unless absolutely sure of the effect.
1. Update All Locations : Y
2. Indexing Sort Sequence : AR
3. Salesperson Flag in Inv. : Y
4. Quantity on Hand Password :
5. Replacement Cost Flag :
6. Warehouse Cost Flag :
7. Update GL Inventory Entry : N
8. Inv. Entry Adjustment Acct :
9. Update GL Change QOH : N
10. Change QOH Adjustment Acct :
11. Change QOH Det, Sum, Port :
Vendor Entry
Vendor Code : 3M 1. Account # : 1254897 2. Sort Code :
3. Name : 3M Minn Mining & Mfr
4. Mail Address: 345 Main Street
: Suite 100
5. Mail Zip Cd : 55406 6. City: Minneapolis Prov/: MN USA
7. Ship Address:
:
8. Ship Zip Cd : 30331 9. City: Atlanta Prov/: GA USA
10. Phone # Phone Description 11. Contact
(954) 845-9817 FAX RALPH LAUREN
14. Lead Time : 2
12. Account Description Pct. 15. Safety Stock : 5
1200 Inventory 100.0 16. Order Frequency : 10
17. 1099 Misc Vendor: Y
13. Normal Term : 8 5% 10TH NET 30T 18. Fed ID#/Soc Sec#:
Financial Reports Setup
1. Corporate Name : Stone Auto Body Supply
2. Balance Sheet Break Account :
3. Income & Expense Break Acct :
4. Inc. & Exp. Subtotal Acct's Subtotal Titles
50 Cost Of Goods Sold Gross Profit on Sales
5. Revenue Account : 40 Revenue
6. Expense Accounts Revenue Accounts
7. Suppress Zero Bal Accounts : Y 8. Suppress Dollar Sign in Rpts:
Holiday Table setup
Location : 1 Perfection Paint Store
1. Holiday Date Description
01/01/2005 New Years Day
05/24/2005 Memorial Day
07/05/2005 4th of July
09/06/2005 Labor Day
11/25/2005 Thanksgiving Day
12/24/2005 Christmas Eve
12/25/2005 Christmas Day
Chart of Accounts Format Listing
10 Assets Asset
100 Current Assets Asset
1000 Cash in Bank Asset
1020 Accounts Receivable Asset
1040 Inventory Asset
140 Fixed Assets Asset
1420 Accumulated Depreciation Asset
1440 Fixed Assets Asset
150 Other Assets Asset
1510 Undeposited Funds Asset
1520 Customer Deposit Asset
1540 Loans Asset
20 Liabilities & Equity Liability
200 Liabilities Liability
210 Current Liabilities Liability
2100 Accounts Payable Liability
2150 Uninvoiced Receiving Liability
2200 Payroll Taxes Liability
2250 Sales Tax Liability
240 Long Term Liabilities Liability
2410 Bank One Loan Liability
2420 Line Of Credit Liability
2450 Truck Loan Liability
300 Equity Equity
3100 Owner’s Capital Equity
3500 Retained Earnings Equity
3999 Current Year Profit <Loss> Equity
40 Revenue Revenue
4000 Taxable Sales Revenue
4010 Non-Taxable Sales Revenue
4040 AR Payment Discount Revenue
50 Cost of Goods Sold Expense
5000 Cost of Goods Expense
5010 Freight Expense
5020 Purchase Discount Expense
5030 Purchase Price Variance Expense
60 Expenses Expense
6000 Rent Expense
6010 Building Repairs & Maintenance Expense
6030 Telephone Expense
6040 Advertising & Sales Promo Expense
6050 Utilities Expense
6100 Payroll Expenses Expense
6110 Group Insurance Expense Expense
6120 Benefit Plans Expense
6130 Owner/Officer Salaries Expense
6140 Outside Sales Salaries Expense
6150 Employee Salaries Expense
6160 Payroll Taxes Expense
6200 Estimates Expense
6250 Freight Expense
9999 Current Year Profit <Loss> Expense