G - G/L V3-4
[IBS Home] [Up] [A - A/P V3-4] [G - G/L V3-4] [P - Payroll V3-4] [A - A/P V1-2] [G - G/L V1-2] [DMAS] [Errors & Messages] [GL Tracking] [Tax Tables]

IBM Server Site

IBS Home Up GI - G/L Inquiry GR - GL Reports GU - G/L Updates Journal Codes Period Processing Setup G/L Transfer Journals What updates G/L? Year End File Changes

 

 

General Ledger Assistance

*IMPORTANT
You are using version 3 or 4 if your system was installed on or after 2005.

Finding General Ledger Numbers

Points to remember General Ledger Version III
All IBS locations installed since late 2005

  • If it hasn't passed through the Invoice Register (MP 1, 5)  it has not been posted to your General Ledger.
  • Review the ARTR (Accounting Transaction File) regularly for any General Ledger entries (MP 2, 7-8).  These items are NOT in your general ledger even though they ARE on your invoice register.
    There are 2 reasons for a transaction not to post directly from the invoice register to the General Ledger

    1.) it is out of balance or
    2.) it has an invalid account number

Points to remember General Ledger Versions I & II
All IBS locations installed 2005 and before

  • If it hasn't passed through the Invoice Register (MP 1, 5) it has not been prepped for posting (GL Versions I & II)
  • Review the ARTR (Accounting Transaction File) for post pending transactions.  General Ledger entries (MP 2, 7-8).  These items are NOT in your general ledger even though they ARE on your invoice register.
  • General Ledger Versions I & II also require you to post via (MP 2, 9) each time you want to send the data over to the General Ledger+

Sales

  • Delivery tickets
    • do not affect your General Ledger numbers
  • Cash Sales
    • do not affect General Ledger numbers until processed through both pre-invoice margin (MP 1, 4) report AND invoice register (MP 1, 5)
  • Credits
    • do not affect General Ledger numbers until processed through both pre-invoice margin (MP 1, 4) report AND invoice register (MP 1, 5)
  • Invoices (Charge Sales)
    • do not affect General Ledger numbers until processed through both pre-invoice margin (MP 1, 4) report AND invoice register (MP 1, 5)

Inventory

  • Received inventory
    • IBS GL Version 3 - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5)
    • IBS GL Software versions I & II - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5) and the ARTR File posting (MP 2, 9)
  • Sold inventory
    • IBS GL Version 3 - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5)
    • IBS GL Software versions I & II - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5) and the ARTR File posting (MP 2, 9)
  • Transferred inventory
    • IBS GL Version 3 - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5)
    • IBS GL Software versions I & II - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5) and the ARTR File posting (MP 2, 9)

Receivables

  • Adjustments
    • IBS GL Version 3 - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5)
    • IBS GL Software versions I & II - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5) and the ARTR File posting (MP 2, 9)
  • Paid on Account
    • IBS GL Version 3 - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5)
    • IBS GL Software versions I & II - does not affect General Ledger numbers until processed through the invoice register (MP 1, 5) and the ARTR File posting (MP 2, 9)

     

Menu Options

  • General Leger Main MENU - GU
    Select this option to access all General Ledger MENUs
  • General Ledger Reports - GR
    Select this option to print G/L reports
  • General Ledger Inquiry - GI
    Select this option to Inquiry on G/L accounts
  • General Ledger Transactions - GU, 3
    Select this option to process journal entries
  • Period Processing MENU - GU, 4
    Select this option to close periods or complete year ending process
  • File Maintenance - GU, 5
    Select this option to manage your G/L Chart of Accounts and format member
  • General Ledger Control - GU, 6
    Select this option for general file maintenance
  • General Ledger Documentation - GU, 22
    Select this option to view online documentation
  • General Ledger Initial Setup and Configuration - GU, 23
    Select this option to manage your initial setup options

Standard Accounting Debit/Credits

Type

Debit

Credit

Sales
  • COGS
  • A/R
  • Inventory
  • Sales
ROA
  • Cash
  • A/R
A/P
  • Expense
  • A/P Liability

 

G/L Transaction Source Codes

  • A =

Accounts Payable

  • H = IBS Post Detail, Reconciled checks
  • U = Posted to the General Ledger
  • A = A/P Post (Active)

Key IBS File

  • gld - General Ledger Description
  • gldhold - General Ledger Hold File
  • glm - General Ledger Master
  • pyd - A/P Detail File
  • pyh - A/P Header File

 

 
IBS Lumber and Building Material Software  Copyright © 2006 IBS Lumber Software Inc (TM)
Last modified: December 5, 2008

IBS Sales & Support (888) 427-1566
Main Office 1-812-547-4640
Fax IBS  1-812-547-9614

IBS Corporation - Building Materials Software for your Lumberyard

All pages contained in this support website are not intended for general public distribution.  Any material here can be considered private, confidential with various copyrights and restrictions against public release.  You 'the browser' cannot legally release this information for general public distribution.

IBS Webmail | IBS Corporate Site | IBS Homepage
remote support:
http://www.gotomeeting.com | remote support download program