Troubleshooting NEOSYS Agency System

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. They will always agree except for error in the NEOSYS system.
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.