Troubleshooting NEOSYS Agency System

From NEOSYS User Support Wiki
Revision as of 12:46, 8 April 2010 by Ashwin (talk | contribs)
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.

Why doesn’t the billing analysis for a particular client agree with the billings shown in the client’s ledger account?

The billing analysis (actual billings) is entirely and only based on the entries in the income and costs accounts. This ensures that the billing analysis is always in agreement with the Profit and Loss Statement.

Although in most cases the entries in the income and cost accounts are one to one with entries in the client and supplier accounts it is possible to post income or costs journals or other entries which have no corresponding entry in the client/supplier accounts. Therefore the billing analysis (and, by extension, the profit and loss) may not always be in precise agreement with the total billings/costs recorded in the client/supplier accounts. In other words it is to be expected.

The way to check the billing analysis report for a particular client is not to check the client accounts but to check the income accounts as follows:

Take a detailed ledger account for all the income accounts for the period in question and then total up all the entries which refer to the client in question by looking at the analysis columns which show on the right hand side of all accounts for income and cost accounts. The total of the entries for the client will definitely agree with the billing analysis if NEOSYS is correctly configured and you have not skipped any income accounts.

Resolving descrepancies between Billing Reports and List of Invoices Reports

The standard NEOSYS Billing Analysis Reports will not always agree with the List of Invoices reports because since lately it picks up the figures from the vouchers and not the invoices.

If you need to run a Billing Analysis as per the invoices as in the Media/Job then the period in the Media/Job Configuration File > Billing Analysis should be a future one - so you need to enter a future period here to allow this to match and change it back to the current one later. Hopefully there will be a way to select either By Invoice or/and By Voucher specifically so that you can have a billing analysis with both the figures and compare any discrepancies.

At a minimum compare the following reports:

  1. List of Invoices: "By Client" option
  2. Billing Analysis: Billings By Client. Select either "Media Only" or "Non-Media Only" depending on which List of Invoices you are comparing.
  3. Billing Analysis: Margin by Client (ditto)


Notes:

  1. You will have to do this for Media and Non-Media separately as there is no combined List of Invoice option.
  2. Use the standard NEOSYS built-in billing analysis reports. Do not use custom reports.
  3. Compare the total for all client for a whole year initially and only examine particular months and clients to further locate any discrepancies.
  4. Errors in custom billing analysis reports should be assumed to be errors in their design unless the standard billing analysis reports also show wrong figures.

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.

Generally there is no need to rerun CREATEANALYSIS more than once unless some time has passed since you last ran it and/or you fear server crashes have occurred since it was last run. You can always redo it as a last resort but it is unlikely to fix things if it didnt fix them recently. Running CREATEANALYSIS will rarely but sometimes fix software errors which can occur anytime of course.

F5
CREATEANALYSIS

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