Mass Mark Invoices as Paid

If you require to mass update a few or several payments for your Invoices or Advanced Payment Invoices, you can download the attached Excel file (at the very bottom) and fill it out accordingly. 

Once filled out provide it to LEX247 Customer Support (support@lex247.com) when completed. 

Description of the fields in the Excel file.  

1. Payment Date
   Enter the exact date the payment was made.
   • • • Use this format: YYYY-MM-DD (Year-Month-Day). For example, if the payment was made on January 1st, 2025, you would enter: 2025-01-01.
         
         
2. Amount
   Enter the amount of money that was paid.
   • • • Make sure to use a decimal point ( . ) to separate the whole number from the cents. For example, 10.50 not 10,50.
       • If you need to reduce a payment, you can enter a negative amount. For example, -5.00 or -1000.00, etc. 
       • Do not use commas or spaces to separate thousands (like 1,000.00 or 1 000,00). Just enter the numbers and the decimal point (e.g., 1000.00).
          
3. Currency
   Specify the currency accordingly for the payment was made in.
   • • • The Currency must be provided in ISO 4217 format, You can find a list of these codes here: https://www.iban.com/currency-codes 
       • Here are some most used Currencies; 
         • • SEK = Swedish Kronor
           • EUR = Euro
           • GBP = Great British Pounds
           • USD = United States Dollar
           • NOK = Norwegian Krone
             
             
4. Invoice Number
   Enter the specific invoice number that was paid or needs a payment adjustment. 
   
   
5. Billing Unit 
   Enter the global unique identifier (GUID) for the specific Billing Unit that this invoice belongs to. This code looks like a series of letters and numbers separated by dashes (for example: a1b2c3d4-e5f6-7890-1234-567890abcdef).
   
   You can find this by going to the Control Panel > Manage Business & Billing Units > click the Billing Unit that the Invoice belongs to and copy the GUID from the URL, examples below. 
   
   The Billing Unit GUID will be in the URL, highlighted below. 
   
   
   If you have created more than one Billing Unit, it may look different, such as below. 
   

Example of a Completed File

After entering the information as required, it should look something like this, as below. 

Once done, please provide it to LEX247 Customer Support (support@lex247.com). 

Important Notes:
We will be checking to see if the formatting is as expected before running the script. 

1. Do not add, edit, change, modify, or move the columns in the Excel file. 
2. The formatting MUST be as described as above for each specified column/row.  
3. LEX247 does not support the payment of Credit Notes, please do not add Credit Note payments to the Excel file. If the payment was moved from Invoice A (where Invoice A has been credited) to Invoice B, simply specify Invoice B in the file by providing the information required.