Entering Lockbox Payments
You can import payments into the system ’s Lockbox Payments area. When payments are imported into the Lockbox, you can edit or adjust payments before posting. This means if you have incomplete information, such as the invoice number isn’t clear, you can find the correct invoice number, edit the payment, and post it. Payments with missing information will automatically appear in the lockbox, but you can set the system to import all payments into the Lockbox.
You must go to Settings > Data Import/Export > Import.
You will use the Payment import. You must add the Lockbox flag to your file if you want all payments to go into the lockbox. The lockbox header should be set to 1 if payment is to be treated as a Lockbox transaction which requires review before being posted.
Important
Payments missing required fields or a payment not matching the exact amount of an invoice will go into the lockbox automatically.
The file must be saved as a .csv. Since all payments will be reviewed in the Lockbox area, you can import data that is missing required fields like invoice number or paying company. But you must have a payment date, amount, and method.
Upload your file and map the fields for import. The system will put all the payments into the Lockbox.
Note
You will be able to change the invoice number and paying company in the Lockbox area.
Go to Billing > Lockbox Payments to complete the process of editing payments and posting payments. You will see all the imported payments and can edit and/or post the payments.
If a payment doesn’t have all the required information, you can’t post the payment, but you can edit and update the information. You can change the paying company, invoice, date, and amount.
If you know the Paying company name, you can select from a list of open invoices. Edited payments will be highlighted in green.
Check the payments you want to post and click on Post Payments.