Troubleshooting NEOSYS Agency System

From NEOSYS User Support Wiki
Revision as of 12:04, 12 March 2007 by 213.42.21.56 (talk)
Jump to navigationJump to search

Resolving unexpected entried in the Financial Ledger Accounts

Basic accounting theory says that if you have a query about an entry in an account, you look at the voucher that caused the entry since this will show you the other side of the entry.

All accounting vouchers generated by NEOSYS Agency System have corresponding entries in the List of Invoices report and Audit Invoices report so there is no doubt about what caused specific entries.

Until you have tracked the ledger account entry all the way back to the List of Invoices report then you do not have sufficient information to troubleshoot entries.

Resolving discrepancies between Billing Analysis and P&L Revenue A/cs

The billing analysis reports of NEOSYS are designed to analyse the income and costs in very many ways (by client, supplier, market, type, sales executive etc) whereas the financial chart of accounts can only analyse the P&L in one fixed way usually by type of income eg Press, TV etc for media and much more varied for non-media jobs.

Normally one would expect that the NEOSYS billing analysis totals exactly match the turnover according to the NEOSYS P&L statement however a discrepancy between the two is possible for the following reasons:

  • You make any manual postings into the P&L Income or Cost accounts
  • You modify, or delete, or simply don't post the invoice journals generated by NEOSYS
  • Incorrect configuration of income and cost accounts on the Media/Job Types File.
  • Error in the NEOSYS software

To track down the cause of any discrepancies you need to:

  1. Take the NEOSYS List of Invoices report and verify that its totals agree with the Billing Analysis report. If they do not, see the section "Resolving descrepancies between Billing Reports and List of Invoices Reports".
  2. Reconcile the NEOSYS entries in the List of Invoices with the detailed ledger accounts one by one with the entries in the P&L income and costs accounts. Using "Account Analysis" in Financial Reports menu to analyse (subtotal) the income and cost accounts "By contra A/c" (i.e. client account) may help to narrow the reconciliation task to individual clients.

Resolving descrepancies between Billing Reports and List of Invoices Reports

Billing Analysis Reports will always agree with the List of Invoices reports except for error in the server or defect in the NEOSYS software.

After locating and fixing the original problem, CREATEANALYSIS will regenerate the ANALYSIS file (on which the Billing Reports are generated) from the invoices and other files.

F5
CREATEANALYSIS

Enter year (upto 3 years back or depends on the clients need)
Enter ALL