Smart Banking- Lockbox Log

Related Links 

Smart Banking Overview

 

What can I see in the Lockbox Log?

 

The Lockbox Log will show the status of all lockbox deposits (most recent at the top) received from the bank. If the deposit was successful, a link to the AR Cash Receipt transaction will be available.

Most Common Status 

- The request was completed successfully. 

- The request was completed successfully, but there are unmatched Owner transactions.

- The request was completed successfully, but could not match the Lockbox ID for the transactions.

 

View Smart Banking Lockbox Log

1. Click Portfolio then Banks. Select the bank using this feature.

2. Under Smart Banking Features, click the date next to Lockbox 

 

mceclip0.png

 

It will then open the Lockbox Log. 

Sample Lockbox Log

mceclip3.png

 

I have some transactions with unmatched owners or an issue with the lockbox ID, what do I do? 

Highlighted below are the 2 possible errors when reviewing the log.

mceclip4.png

 

- The request was completed successfully, but there are unmatched Owner transactions.

Download the Lockbox Error File in the Bank Attachment Gallery and verify the customer account number. 

- The request was completed successfully, but could not match the Lockbox ID for the transactions.

Download the Lockbox Error File in the Bank Attachment Gallery and verify the Lockbox ID in your Bank account matches what your bank gave you.

 

How do I get to the Lockbox Error File? 

Each line with an error will have the name of the lockbox error file in the Bank Profile Page Attachment Gallery. 

Example: 

 

mceclip5.png

 

1. Copy the file name listed in the error. 

2. Go to the Bank Profile Page. 

3. Scroll to the bottom of the page, and locate the Attachment Gallery. Click View All 

 

mceclip6.png

 

4. To easily find the lockbox file, switch to mceclip8.png list view.

mceclip7.png

 

5. Click Ctrl+F and paste the lockbox file name previously copied.

In list view, the full file name is visible. This will be useful if there are a lot of files in your attachment gallery. 

6. Click the + sign to select the file. Once selected, it will turn to a green checkmark.

mceclip9.png

7. Once selected, switch back to the Card View mceclip10.png

mceclip11.png

 

8. Click the icon to open the file. 

mceclip12.png

 

9. This will open up in another tab the actual transactions from the bank.

The lockbox follows the Default Lockbox Format

 

10. Open a text editor like NotePad. Highlight all of the records listed in the browser then with your mouse hold down the right mouse button and choose copy or CTRL+C. 

11. Place your mouse in the body of your text editor and hold down the right mouse button and choose Paste

 

 

12. You will need to correct the error and save the file to a location on your computer.

 

How do I upload the corrected file? 

1. Click Accounts Receivable then Cash Receipts

mceclip1.png

 

2. Click Cash Receipts - Lockbox

mceclip2.png

3. Select the File Format

4. Enter the Post Date  

5. Click Select Files and upload the lockbox file.

If the upload was successful, the following message will pop up.

 

mceclip4.png

 

7. On the Cash Receipts page, click Outstanding Batches.  

8. Post an Accrued Payment

Did you find this article helpful?

0 out of 1 found this helpful