Pre-registration via a webservice
The current setup does not provide an optimal connection between the Spend Cloud and the financial system, particularly concerning VAT registration. The purchase invoice is only sent to the financial system once it has been fully approved. This timing is too late. Depending on the capabilities of the financial system, two types of pre-registration can be utilized: with or without rules. Both types of registrations are explained below.
1. Pre-registration without invoice lines
When an invoice is coded and sent to an approver in the Spend Cloud, it can be pre-registered. The following entries will be made:
- Entry for the creditor
- Entry for VAT
- Temporary entry on an 'interim pre-registration account'
- The invoice is blocked for payment
If your organization wants to work with pre-registration, contact the Support department to enable this feature.
Booking Steps
Step 1
Immediately after the initial registration of a purchase invoice in the Spend Cloud, you must also record it in the financial system. This is necessary for recording the creditor, VAT, and costs on an 'interim pre-registration account'.
Journal Entry:
2xxxx Interim Pre-registration Account 100.00
1xxxx VAT 21.00
To 1xxxx Creditors 121.00
Step 2a -> Approved invoice:
After a purchase invoice is fully approved in the Spend Cloud, a final registration of costs against the 'interim pre-registration account' will be made. The invoice header will be resubmitted with only the document number and a different status, namely 'Approved'.
Journal Entry:
41xxx Cost X 50.00 (e.g., cost center 2000, period 11)
42xxx Cost Y 50.00 (e.g., cost center 3000, period 12)
To 2xxxx Interim Pre-registration Account 100.00
Step 2b -> Definitively disapproved invoice:
After a purchase invoice is definitively disapproved in the Spend Cloud, a complete reversal of Step 1 will be submitted.
Journal Entry:
1xxxx Creditors 121.00
To 2xxxx Interim Pre-registration Account 100.00
To 1xxxx VAT 21.00
Principles and requirements
- After an invoice is sent in the Spend Cloud, the invoice header will be locked. No further changes can be made to the exported data from Step 1.
- The export files from Steps 1, 2a, and 2b are submitted in this sequence and simultaneously in the 'Export' section (to prevent Steps 2a or 2b from being submitted before Step 1).
- If an error is made in the invoice header, the invoice must be definitively rejected and re-added.
- The export of "Costs in Transit" remains as it is. This is an accumulated posting of costs (sum of costs per ledger account-cost center combination) in journal form in period x (of all costs until period x+1 of invoices not yet exported through Steps 2a or 2b) with a contra entry on an 'in-transit costs account'. A complete reversal of the preceding entry is also immediately available for period x+1.
Exporting pre-registrations
Pre-registrations can be submitted in two ways. You can export an approved invoice (see section 3.2), which will also export all pre-registrations of the respective administration to the financial system. Alternatively, pre-registrations can be separately submitted to the financial system as follows:
- Go to the 'Invoice Processing' section > 'Export'.
- At the top of the overview, there is a button labeled 'Export Pre-registration' to export pre-registrations per administration.
- In the subsequent screen, the period can be adjusted if needed. Always choose 'Automatic Period Allocation: No' and then fill in the last open period under 'Adjust Period'. This ensures that all pre-registrations, potentially still assigned to a closed period (in the financial package), are updated to the selected open period.
Example: If the financial system is closed until period 03-2023, choose 04-2023. This way, pre-registrations with a period earlier than 04-2023 will be posted in 04-2023. Confirm by clicking 'Export'.
- You will now be taken to the 'Export Files' screen. A status bar will indicate the duration of the process.
- In the meantime, you can leave this screen and even close your browser and computer. Exporting is a background process that continues at all times. Once completed, you will receive a report by email. You can also download the report in the 'Export Files' section.
If a pre-registration fails, the reason will be displayed in the export report. Any invoices that fail will be automatically resubmitted in a new export request. Therefore, it is necessary to address the indicated issue(s) in the export report before re-exporting the corresponding invoices.
Intermediary account
Based on the general ledger account specified in the administration, it is determined which 'intermediary pre-registration account' will be booked. The 'intermediary pre-registration account' used will be the general ledger account specified in the administration for this type of expense:
When an invoice is approved and exported from the Spend Cloud in the 'Invoice Processing – Export' menu section, the original 'intermediary pre-registration account' will be reversed. An adjustment will be made to the document number, adding a "9" as the first character (YYXXXX -> 9YYXXXX). This prevents the financial system from generating an error message about the document number already being in use. Since the payment reference is the same, the entries will still be shown together in the invoice overview. Costs will also be booked, and the invoice will be unblocked for payment.
- Go to the Invoice Processing > Export section
- At the top of the overview, you'll find the "Export Pre-registration" button to export pre-registrations for each administration.
- In the following screen, you can optionally adjust the period. Always choose "Automatic Period Allocation: No" and then fill in the last open period under "Adjust Period." This ensures that all pre-registrations that might still be pre-registered in a period that has been closed within the financial system are updated to the selected open period.
Example: If the financial system is closed up to period 03-2023, then choose 04-2023. This way, pre-registrations with a period earlier than 04-2023 will be booked in 04-2023. Confirm by clicking the "Export" button.
- You will now arrive at the "export files" screen. A status bar will indicate the duration.
- Meanwhile, you can simply exit this screen and even close your browser and computer. Exporting is a background process that will continue at all times.
- After completion, you will receive a report via email. Of course, you can also download the report in the 'export files' section.
If a pre-registration fails, this will be indicated in the output report along with the reason. Each invoice that fails will be automatically re-offered when a new export order is given. Therefore, it is necessary to address any necessary errors as indicated in the output report before re-exporting the respective invoices.
It is possible to export multiple batches of invoices to the financial system at once, even when they are within the same administration. However, this is subject to the capabilities of the financial system. Additionally, it is theoretically possible that an approved invoice could be offered to the financial system before the invoice is pre-registered (because the pre-registration is in a batch that is not yet ready). In this case, the Spend Cloud will provide an error message, and the approved invoice will not be offered.
Definitively disapproved invoice
When an invoice is definitively disapproved, the original 'intermediary pre-registration account' will be reversed.
Error message and reversal of export file
During exporting, you may receive an error message if an invoice is not accepted by the financial system. This invoice will be returned to the 'export' section to be re-exported after adjustments.
The Spend Cloud also offers the option to undo the entire export. Keep in mind that pre-registration entries and definitively approved cost entries will be reversed. In this case, manually reverse the made entries in the financial system.
2. Pre-registration with invoice lines
- Purchase invoices, after being initially fully coded and sent as final purchase journal entries in Spend Cloud Invoice Processing, are offered in the next export via the webservice. These are then blocked for payment.
- Upon approval of the full invoice, the payment block will be lifted in the next export via the webservice.
- After definitive rejection of an invoice, it will be fully reversed (using the coding known at that time) in the next export via the webservice.
- Changes to an invoice that occur after initial full coding and sending will not be communicated in any form.
Related Articles
Reversing an invoice export
Once an invoice has been approved by the reviewer(s), it is ready to be exported in the Export menu. It may happen that you have exported an invoice, but later it becomes apparent that the invoice needs to be modified in the Spend Cloud. In such ...
Status Paid
In the Spend Cloud, it is possible to use the 'Status Paid' functionality. With this feature, invoices that have been previously exported to the financial system can be marked as 'Paid' in the Spend Cloud once they are fully paid. How can I use the ...
Export invoices
Once an invoice has been approved by the assessors, it is ready to be exported in the Export menu section. Within this overview, you can review or edit the invoices one last time before they are processed in the financial system. Exporting invoices ...
New PDF view when encoding invoices
At this moment, we are in the process of transferring all Spend Cloud environments to a new OCR solution, SmartScan. Would you like to read more about the benefits of invoice processing with SmartScan? Then read the article Invoice Processing with ...
Configuration settings for Invoice Processing
In the menu section Configuration Settings / Invoice Processing, you will find settings that apply to the Invoice Processing module. Also, read this article for more information on configuration settings. Make sure you understand what each setting ...