Product Support
Module: SALES ADMINISTRATION
Menu Option: WET REGISTER LISTING, WET REGISTER ARCHIVE, WET REGISTER HISTORY LISTING

Problem:

Do I need to manage and reconcile WET in Ezy at the end of every BAS period?

   
Cause:
   
Solution:

Yes, it is suggested that you reconcile WET. It will be a simple process if the WET register is properly managed.

 

Print the WET Register at the same time you roll your Debtor month on the last day of the BAS period. Do not enter a "From Date", but enter the "To Date" as the last day of your Financial Year. This will ensure that you include all transactions that were updated. Archive the WET Register by entering the last day of the Financial Year and the BAS Month as the "BAS Document Id. ". This will ensure that all printed transactions are archived. If you need to print a listing with the exact transactions your listing had, just use the WET REGISTER HISTORY LISTING and enter the BAS Month you have used with the archive.

 

Now run the GENERAL LEDGER REPORTS, GL LEDGER for the relevant months that fall in the BAS period to obtain the General Ledger amounts for the WET Clearing and WET State Rebate Clearing account. These totals should reconcile with the Total WET and State Rebate amounts on the WET Register Listing. If not, check the following:

 

  • Check that the correct Selection Criteria was selected when running the reports.
  • Check for invalid transactions in the General Ledger e.g. Journal entries. Your WET General Ledger accounts should only contain entries originating from the Sales Area (Source = SALINV, SALCNT, SALCDS, SALMAI)
  • Check for transactions belonging to a previous or future BAS period that were updated in the current GL Months specified when the GL Ledger was run. The use of the System Parameter 'General: ACCT Validate Trans. Month' will prevent this from occurring.

 

You can run all the reports by transaction SOURCE to simplify the search process. Use the "Batch Ref." on the WET Register Listing and the GL Ledger when trying to search for the problem. When the problem is identified, you should write up a reconciliation report that clearly identifies the problem. Attach all printed reports to this reconciliation report and file as you will need it for future reference. It is only necessary to process corrective Journals with end of financial year, unless internal practice requires otherwise.

   
See Also

 
    Email


Author:   Jacques Olivier
Published:    
Last Modified:  
Products:   EzyWine, EzyAuction, EzyAccounts
Version:   2003.01.xx | All
Approved By:   Angela Cugola

© 1997-2004 Ezy Systems Pty Ltd - All rights reserved Login
Site Design By: Adrian Lock