Reconciliation Report

CCH Practice Management integration with Twinfield works by using a synchronisation process.  From time to time, it is possible to find a difference between your total debtors figure on the debtors reports in CCH Practice Management when compared to the balance on the debtors control within Twinfield.

Possible causes of these differences can include

• Client debtors cash transaction posted directly to CCH and without an adjusting transaction being posted to the debtors control in Twinfield
• Client receipt in CCH Practice Management has been reversed using the reverse option without the adjusting entry being posted back to CCH Practice Management
• When using multiple companies in Twinfield and CCH Practice Management, a balance on a clients debtors control has been transferred in CCH Practice Management from one billing company to another and the intercompany transaction has not been reflected in Twinfield
• The nominal code set against an assignment used on a client bill in CCH Practice Management is not a valid nominal code in Twinfield
• A bank statement or paying in slip has been posted provisionally to Twinfield and not made final on the same day
• A line on the bank statement in Twinfield has been coded to a client code which is closed or changed in CCH Practice Management
• An adjustment has been posted to the debtors control in Twinfield which has not been reflected in CCH Practice Management

To help with reconciling the two balances the following notes explain how to create a report in Twinfield which can be used to balance against transaction in CCH Practice Management

Creating the reconciliation report

Find the report General Ledger / Transaction list in the report management screen and click on the edit pencil to open the report designer. The report designer works best when the screen is maximised.

Name the report

In the Settings header enter a name of CCH Practice Management Reconciliation

The following changes are made to the report design

Remove the groups which are not required  Remove the group for Transaction number by clicking on the red x to the left of the darker grey area of
Remove the columns which are not required from the detail section of the report From the report columns, the lighter grey area, delete the following by clicking on the red x to the right of the column name. Transaction line General Ledger account VAT Code VAT Amount Regime
Add additional columns to the detail section of the report Add the following columns to the report by dragging the field from the list of available at the foot of the page and dropping on the lighter grey area to position the field where it is required. Transaction number - add as first column to the left of the existing Transaction date column Entry date - add as last column after User Modification date - as as last column after Entry date
Change the sort order of the report Against the column for Transaction date, click the diamond shape to add this column as a sorted column. The shaded area of the diamond demonstrates the order and the number is the position within the sorting.

Amend the criteria options

From the Criteria tab on the report designer make the following changes

Period	Untick Default and remember value
Transaction type category	Untick hidden
Transaction type	Untick remember value
Transaction number	Untick remember value
Transaction date	Untick remember value
Modification date	Untick remember value
General ledger account	Untick remember value Enter your Debtors Control code in the first box Tick Locked
Cust./supp./Cost centre	Untick remember value
Invoice no.	Untick remember value
User	Untick remember value

Save the new report

At the bottom of the report deisgner screen, click Save copy orange button.

Note - If you are editing your report after saving, please click Save rather than Save copy to overwrite your custom report.

Report Security

New custom reports are restricted to use by the designer by default.  If your report is to be run by other Twinfield users the Access rights will need to be edited.

After saving the customer report, find the new report in the Report Management list and click on the Access rights icon at the end of the row.
To allow all users access to this report, delete the two entries in the custom access rights section by clicking on the red X against each row.
Click the orange Save button to save the amended Access rights