new gl tools greg herrington and chris curtis wednesday august 13, 2014
TRANSCRIPT
New GL ToolsGreg Herrington and Chris Curtis
Wednesday August 13, 2014
New GL Tools
• GL Reporting• AR Reconciliation• Inventory Reconciliation• ION/Batch Count• GL Batch Changes• Troubleshooting Discrepancies• Balancing Daily Transactions
GL Reporting
• Scans all DRCR tables in eoStar.• Based on date range (eoStar or Ledger)• DX Options• Grid Options• Layouts• Print / Export• Grouping
Reconciliation Tool Setup
• Ledger account type• GL Toolbox• Erase unused accounts• Scan for setup issues• Assign account types• Set reckey to external account number
• Bank Accounts
Reconcile GL to ION AR Report
• Receivable account type
• ION• Order Price – Order Discount + Sales Tax – Payments – Writeoffs + Charges
Reconcile GL to ION AR Report
• Possible Discrepancies• Matching Debit and Credit Accounts• Ledger impact on non-Receivables account• Applies dated before a transaction exists• Ledger Date changes
Reconcile GL to Inventory Valuation
• Inventory ledger account type
Reconcile GL to Inventory Valuation
Reconcile GL to Inventory Valuation
•Possible Discrepancies• Ledger impact to non-inventory accounts• Ledger impact from non-inventory transactions• Billing codes
• Cost has GL impact flag• Return reasons
Reconcile ION to Batch Count
• Can be used for Full and Cycle counts• ION - all transactions up to midnight of selected day.• COUNT – last inventory batch on selected day
Reconcile ION to Batch Count
• Details• Shows transactions in different batches
GL Batch Changes
• GL closeout marking• Automatic date changes
GL Batch Changes
• No more negatives• Change GL dates / accounts• GL Export Panel
Troubleshooting Discrepancies
• I have a Discrepancy, what do I do now?• Step 1: Validate eoStar Transactions match eoStar GL Entries
• This can be done by running a series of ION Reports in conjunction with the GL Reporting Tool
• This process will help to narrow down where the potential issue is• Step 2: Validate eoStar GL Entries match Entries in Accounting Software
• Using the GL Reporting tool we can generate what was exported in specific batches that were sent to the accounting software
• The GL Reporting tool will also allow us to view overall account impact for a time period which we can compare to what the accounting software shows
Balancing Daily Transactions
• eoStar walkthrough
