CRM6 Billing – Run the CRM6/11 report

Updated Mar 16th, 2021

Who is this guide for?

Accounts Users, Accounts Supervisors, Case Management Supervisors and System Supervisors

Osprey can provide you with a CSV file to upload all your criminal claims to the LAA portal, as well as automatically posting all the bills and receipts for your legal aid claims.

System Setup

To use the CRM6 auto billing, the system must first be set up correctly. You can if you wish, simply produce the CRM6/11 reports and post the bills and receipts yourself manually, but to speed things up we recommend use of the auto billing functionality.

Please use our guide here to ensure your system is set up correctly for the CRM6 auto billing.

Set up your matters for billing

Each matter that you wish to claim for must be correctly set up within the system for it to appear for billing. To run through our check list click here.

Run the reports and bill your matters

Currently, the CRM6 report MUST be run using Internet Explorer.

To run the CRM6 and 11 reports, navigate to Reports > Miscellaneous > Contract Work Reports. Ensure that Microsoft Excel is not currently running.

Select the CRM6 & CRM11 report from the Report: list box.

Leave the Start Date as entered.

Select the Branch you wish to run the matters for.

Leave the currency as Pound Sterling.

If you wish, you can select the Class to run, or leave as All for all claim types.

Click Run Validation. The list of matters available to bill will show.

Tick each matter that you wish to bill, if any disbursements have been posted to the client ledgers, these will appear to the right of the list, and you can select whether they are vatable or not (default is vatable).

When ready to run the billing, select Run in the top left hand corner. If you have selected to auto bill your matters, you will see a prompt displaying the posting date that the system will use, please check this carefully and select Cancel if incorrect, or OK if correct. If the posting date is incorrect you will need to amend this from Supervisor > Financial Periods > Set Posting Period Date.

Click to enlarge

When you are happy that the posting date is correct, click OK to run the CRM6/11. Excel will open. Wait for the spreadsheet to finish its calculations, then enter the submission date in the summary page box C3 as shown below. You can print this page if you wish to compare with the LAA portal summary sheet.

Click to enlarge

Print your CRM11s

To print the CRM11s from the spreadsheet, select the CDS11 form tab, then click the Print All button:

Click to enlarge

Print your CRM6s

If you wish, you can also print your CRM6s for your records. Navigate to the CDS6 Form tab, and click the Print All button:

Click to enlarge

Generate your CSV file for upload to the LAA portal

To generate your uploadable CSV file, navigate to the SPOCC Matter Outcomes sheet and click the Generate Online Submission button. Select the folder you wish to save the file into on your local machine or network drive, and click Save:

Click to enlarge

You can now log into your LAA account and upload the submission file.

Should you need to, you can reprint any submission batches that you have generated in Osprey. Click here to see our instruction guide.

Balancing your LAA and Office Banks

Once you have uploaded the submission to the LAA web site, ensure that you reconcile the LAA Claim Summary back to the Osprey Billing Summary. Any changes you make to the data on the LAA web site after uploading it will need to be replicated on Osprey, undoing and reposting any transactions as necessary.

You will need to transfer the balance from the “dummy” office bank you created for the receipt postings to reduce the balance on your monthly payments control ledger.

If the control ledger is a client ledger card, you need to use the posting type Office Bank Payment and select to post from the “dummy” bank. If the control ledger is a nominal, you will need to use the posting type of Payment, selecting to post from the “dummy” bank.

In the Banks and Journals area, select the “dummy” office bank and click Refresh.

Tick the transaction you just posted on the “dummy” bank.

Now select to Tick by Ref and enter the batch number of the CRM 6 batch you just ran – ensuring that the total equals the amount for that batch.

Once these items have all been ticked, the bank balance on your “dummy” bank should return to 0.