General Ledger

[Rees Watkins]

Hi
Is there any documentation on setting up the General Ledger area?
I do not understand how all these settings match to the set of books my accountant wants.
For example she wants cash payments paid to CASH IN BANK AND ON HAND[111000
So I set:
Payment method Id / GL Account Id
mapped "Cash" to   "CASH IN BANK AND ON HAND[111000]"
but I do not get entries for Sales in my trial balance.
and
FinAccount Type Gl Account
Bank Account to   "CASH IN BANK AND ON HAND[111000]"

Thank you
Rees
-------------------------------------------------------------------------------------------------
Chart of Accounts
I presume you add accounts you wish you business to use?
Account Id Gl Account Type Id Gl Account Class Id Gl Resource Type Id Gl Xbrl Class Id Parent Gl Account Id Account Code Account Name Description Product ID Posted Balance
111000 Current Asset Cash and Equivalent MONEY   110000 111000 CASH IN BANK AND ON HAND     1,181.1
120000 Accounts Receivable Current Asset MONEY   100000 120000 ACCOUNTS RECEIVABLE     -1,181.1
210000 Accounts Payable Current Liability MONEY   200000 210000 ACCOUNTS PAYABLE      
221100 Commissions Payables Current Liability MONEY   220000 221100 ACCRUED COMMISSIONS DUE      
224000 Current Liability Current Liability MONEY   220000 224000 SALES TAX COLLECTED      
400000   Revenue MONEY     400000 SALES      
401000   Revenue MONEY   400000 401000 GENERAL SALES      
409000   Revenue MONEY   400000 409000 MISCELLANEOUS SALES      
410000   Cost of Goods Sold Expense MONEY   400000 410000 DISCOUNTS ON SALES      
500000   Cost of Goods Sold Expense MONEY     500000 COST OF GOODS SOLD      
801000   Cash Income MONEY   800000 801000 INCOME / LOSS FROM BUSINESS (NET OF EXPENSES)      
810000 Interest Income Cash Income MONEY   800000 810000 INTEREST INCOME ON FINANCE CHARGES OR CUSTOMER ACCOUNTS      
GL Account Type Defaults
"Gl Account Type Id"  "Gl Account Id"
I do not understand why this mapping is needed. The "Gl Account Id" account already name seems to indicate the account already knows it try.
Accounts Payable [210000] 210000 ACCOUNTS PAYABLE Remove
Accounts Receivable [120000] 120000 ACCOUNTS RECEIVABLE Remove
Cost of Goods Sold [500000] 500000 COST OF GOODS SOLD Remove
Other Income [801000] 801000 INCOME / LOSS FROM BUSINESS (NET OF EXPENSES) Remove
Sales [400000] 400000 SALES Remove
Tax [224000] 224000 SALES TAX COLLECTED Remove

Product GL Accounts
"Product ID" "Gl Account Type Id" "GL Account - Update"
???

Product Category Gl Account
"Product Category Id Gl" "Account Type Id GL Account"
???

FinAccount Type Gl Account
"Fin Account Type Id" "GL Account ID"
What goes here?
Bank Account    111000 CASH IN BANK AND ON HAND---111000 CASH IN BANK AND ON HAND120000 ACCOUNTS RECEIVABLE210000 ACCOUNTS PAYABLE221100 ACCRUED COMMISSIONS DUE224000 SALES TAX COLLECTED400000 SALES401000 GENERAL SALES409000 MISCELLANEOUS SALES410000 DISCOUNTS ON SALES500000 COST OF GOODS SOLD801000 INCOME / LOSS FROM BUSINESS (NET OF EXPENSES)810000 INTEREST INCOME ON FINANCE CHARGES OR CUSTOMER ACCOUNTS

Payment type / GL Account type Id
"Payment Type ID" "Gl Account Type Id"
Is this the account payments go into
Customer Payment Accounts Receivable  
Sales Tax Payment Accounts Receivable  
Sales Invoice
"Description" Default Gl Account Id" "Override Gl Account Id" "Active Gl Description"
not changed

Purchase Invoice
"Description" "Default Gl Account Id" "Override GL Account Id" "Active Gl Description"
not changed

Payment method Id / GL Account Id
"Payment Method Type" "Gl Account Id Default" "Gl Account Id"
all mapped to
 "CASH IN BANK AND ON HAND[111000]"
Cash  CASH IN BANK AND ON HAND[111000] 122000 :  Remove
Credit Card CASH IN BANK AND ON HAND[111000] 122000 :  Remove
Variance Reason Gl Accounts
"Variance Reason Id" "GL Account ID - Update"
Credit Card Type Gl Account
"Card Type" "GL Account ID"
Map account cc payment to go to as my accountant wants cc payment to go to bank I mapped this to
 "CASH IN BANK AND ON HAND[111000]"
CCT_VISA    111000 CASH IN BANK AND ON HAND---111000 CASH IN BANK AND ON HAND120000 ACCOUNTS RECEIVABLE210000 ACCOUNTS PAYABLE221100 ACCRUED COMMISSIONS DUE224000 SALES TAX COLLECTED400000 SALES401000 GENERAL SALES409000 MISCELLANEOUS SALES410000 DISCOUNTS ON SALES500000 COST OF GOODS SOLD801000 INCOME / LOSS FROM BUSINESS (NET OF EXPENSES)810000 INTEREST INCOME ON FINANCE CHARGES OR CUSTOMER ACCOUNTS Remove
CCT_MASTERCARD    111000 CASH IN BANK AND ON HAND---111000 CASH IN BANK AND ON HAND120000 ACCOUNTS RECEIVABLE210000 ACCOUNTS PAYABLE221100 ACCRUED COMMISSIONS DUE224000 SALES TAX COLLECTED400000 SALES401000 GENERAL SALES409000 MISCELLANEOUS SALES410000 DISCOUNTS ON SALES500000 COST OF GOODS SOLD801000 INCOME / LOSS FROM BUSINESS (NET OF EXPENSES)810000 INTEREST INCOME ON FINANCE CHARGES OR CUSTOMER ACCOUNTS Remove
Tax Authority GL Accounts
"Tax Authority Geo" "Tax Authority Party" "GL Account ID - Update"

Party Gl Accounts
"Party Id" "Role Type Id" "Gl Account Type Id" "GL Account ID - Update"



      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html