AUTOMATIC POSTINGS  

The Automatic Postings function enables you to upload multiple one-off postings using a spreadsheet to avoid having to manually enter transaction data via the One-off Postings page. The screenshot below illustrates the format of the Transaction Import spreadsheet giving data examples for reference:

The import spreadsheet requires the following data to be entered for each transaction line:

A copy of the Excel import template can be downloaded from the Automatic Postings page by navigating to Finances>Automatic Postings and clicking the Excel icon as shown in the screenshot below: 

IMPORTING TRANSACTIONS

Once complete the import file can be imported to CasparCloud -  please note that transactions can be reconciled at the point of upload, but this should only be required where customers do not reconcile on the system and simply upload pre-reconciled transactions to client accounts. 

Save the import spreadsheet to a location on your PC. 

1. Go to the Finances menu on the left-hand shortcut bar
2. Under the Finances menu select Automatic Postings 
3. Click Upload. CSV / .XLSX File
4. Navigate to the location of your saved import file, click the file, and select Open
5. You’ll receive a message to confirm that the file is being processed by the system followed by the validation process bar. (The import process takes place on the server in the background so you can navigate away from the page  and the system will continue to action the task)
6. Once complete you will be directed to the Errors and Warnings page,  as shown below: 

     

7. If there are no errors or warnings click  Confirm to start the import of the file. Please note that you can also cancel the file import at this stage. (Please refer to the Validation section if errors/warning are encountered) 
8. The Import One-Off Postings popup will display where you can opt to reconcile the transactions on import. Please note transactions should only be set to reconcile if you do not use CasparCloud to reconcile expected activity on your accounts. 
   

1. If you do not wish to reconcile the transactions simply click Save and the transactions will begin to import to the Finances>One-Off Postings page. 
2. If you want to reconcile the transaction on import tick the ‘Reconcile Transactions’ check box and enter the date you wish the transactions to be marked as reconciled followed by Save. 

9. The transactions import will begin and if there are a large number of transactions an Import progress bar will display. 
10. Once complete, an Upload Successful message will be displayed confirming the total number of transactions and total value. 
    

IMPORT VALIDATION

When importing an one-off postings file, the system validates the contents of each field to ensure that the data can be correctly matched to clients and loaded to the system. If any data is invalid, you will be presented with a warning in the import preview confirming the issues preventing the file uploading, as shown in the example below: 

File Validation errors:  

1. Date is in the future (Over 28 days in the future)
2. Invalid method (The Transaction Method does not exist in Admin> Data Maintenance> Reference Data > Transaction Methods for the selected posting type Income/Expense)
3. Invalid Type (The Transaction Type does not for this posting type (Type does not exist in the Transaction Type list Admin> Data Maintenance> Transaction Types for the selected posting type Income/Expense)
4. Not Found (Client Code column) – a client does not exist with this code (Client code not found on the system)
5. Not Found (Account Number column) -  the account number is not valid for this client code (No matching account number for the client code)
   

File Validation Warnings:

1. Duplicate – the transaction already exists on CasparCloud. This may indicate that the file has already been imported. 
   

CORRECTING ERRORS / WARNINGS

If validation errors occur the Confirm will be disabled preventing the file from being imported, you have the option to Cancel the import and make the recommended changes in the file before re-uploading or if there are a small number of changes the transactions can be amended on screen. 

To correct an error action the following:

1. Click on the transaction and the Edit Automatic Postings popup will display as shown 

2. Correct the required information 
3. Save the Automatic Posting
4. Repeat for all errors and once complete you will note that the Confirm button enables on the Automatic Postings page. 

Warnings

If warnings are encountered i.e. where a duplicate transaction has been found you will be able to proceed with the import but you must confirm that you are happy to ignore the warnings before importing. Please ensure that you have not inadvertently uploaded a file that has already been added to the system before continuing.  

1. Click Confirm to proceed with the transaction import 
2. In the Import Unbatch Postings popup click the ‘Ignore Warnings’ check box as shown
3. Click Save to proceed with the import.