Modifying a Banking Import Batch's Details

Import Receipts creates sales receipts from a CSV file collected from your bank. The imported receipts are in a batch, which can be modified.

1. On the Sales menu, click Ledger.
2. From the toolbar, click Import Receipts. The Banking Import Batch Management window opens. Lists of imported batches of sales receipts are listed.
3. Right-click the batch, and from the context menu, click Modify Batch Details.
4. Displayed are:
   • Line No. – line of the sales receipt from the import file
   • Date – sales receipt transaction date from the import file
   • Description – from the import file
   • Amount – from the import file
   • Status – status of the line within the imported receipts batch.
     • Auto-Allocation Performed – sales receipt created using details from the file and Horizon, and an attempt has been made to allocate sales receipt to sales invoice or credit. If the attempt is unsuccessful, you will have an unallocated sales receipt.
     • Payment Created – auto allocation was not selected. The sales receipt has been created.
     • Imported Not Processed – The initial status, so if the line continues to have this status, it's likely a rule has stopped the process. The sales receipt has not been created at this point.
     • Trader Not Found – the customer has not been found from the trader code in the file, or from a trader code in the description (if the option was selected) or from the import rules.
     • Invalid Data – the data in the record was not in the expected format, for instance, the date could have the wrong separators, letters may be in a numeric or date record, the month is not 1-12. Check the line and amend the data.
     • Error See Audit – click the Audit tab and consult the log. The error occurred while processing the line.
   • Imported Trader Code – string that matched to a trader code found in the record, description or rule. See Matched Trader Code for the trader code to which this string matched.
   • Imported Sort Code – sort code found from record or rule.
   • Imported Account Number – account number from record or rule.

     Note: These fields are only visible if you have specified them in Define Import.

   • Trader Match Type –
     • Matched From Received Trader Code – code in record;
     • Matched From Trader Code in Description – code found in description;
     • Matched Using Rules – match made using rules for this trader;
     • Matched From Received Account and Sort – found the bank account details for the customer on the Trader card, from the records;
     • Matched From SINV in Description – matched from SINV document number in description;
     • Matched From Sort and Account in Description – found the bank account details for the customer on the Trader card, from the description;
     • Match Abort Due to Rules – an ignore rule has stopped a possible match;
     • No Match Found – no trader found in record or description;
     • Manual Match – the import routine could not find the customer, but a user has then selected one.
     • Match Not Attempted – usually due to invalid data;
     • Failed: Multiple traders matched – two traders may have the same bank details, or, a similar string is matched.
   • Matched Trader Code – the trader code for the customer that was matched
   • Matched Delivery Trader Code – the customer branch code matched.
   • Payment – receipt reference number
   • Outstanding – amount of money on that receipt that has not been allocated. When fully allocated, this is 0.00.

 

See Also