Apply cash
Remittances
Read remittance advice from a shared mailbox or an uploaded file, find the customer and the payment, and review the match suggestions before you apply them.
updated: applies-to: 1.2.0.0
Use the remittance advice that customers send to apply their payments to the right invoices. Bitta Collections reads a mailbox through the Business Central Email module, or a file that you upload. It finds the customer and the payment, then creates match suggestions that a person accepts.
Applies to: Bitta Collections 1.2 on Business Central online, version 28 or later.
Before you start
- Use a mailbox that receives only remittances, for example a shared accounts receivable mailbox. The job queue user must be able to read it.
- Add that mailbox as an email account in Business Central with the Microsoft 365 or Current User connector.
- You need the BAA COLL SETUP permission set (the Administrator set) for the setup and BAA COLL EDIT (the Collector set) to work remittances.
- Read Mailbox Now and Find Payment need a seat of the Bitta Collections license.
Set up the remittance mailbox
- Open Bitta Collections Setup and go to the Remittances FastTab.
- Choose More ways to collect > Choose Remittance Mailbox and pick the email account. Remittance Mailbox shows your choice.
- To read a folder other than the inbox, choose Choose Folder. A blank Remittance Folder Name means the inbox.
- Choose Test Mailbox. It reads up to five unread emails and tells you how many it found. Nothing is stored or marked as read.
- Turn on Remittance Inbox Enabled.
| Field | What it does | Default |
|---|---|---|
| Mark Remittances as Read | Marks each email as read after it is stored | Yes |
| Remittance Category | An Outlook category put on the stored emails | blank |
| Max. Remittances per Run | The most emails read in one run | 50 |
| Remittance Match Window (Days) | How many days before or after arrival the payment can be dated and still match | 14 |
| Last Remittance Read | When the mailbox was last read (read-only) | - |
Bitta Collections never deletes or moves an email.
What the daily job does
The collections job reads the unread emails of the mailbox every weekday, in its first phase. For each email it:
- Stores the body and each attachment as a remittance on the Remittance Inbox page.
- Reads the lines: invoice numbers with amounts, the stated total, the payment reference and the payment date. It reads the email body, CSV and text files and Excel (.xlsx) files.
- Finds the customer by the sender address, from a contact or customer email, or else by the invoice numbers on the lines.
- Looks for a payment with the remittance total within the match window: an unapplied payment, or a line of a payment reconciliation journal.
- Creates match suggestions for that payment and sets the status to Matched.
Choose Read Mailbox Now on the Remittance Inbox to do the same at once. An email without invoice numbers or amounts is set to Ignored.
NOTE
Nothing is applied automatically. You accept the suggestion on Unapplied payments or in the Payment Reconciliation Journal, and post as usual.
Upload a remittance file
For a remittance that came by post or through a portal, choose New from File on the Remittance Inbox. Upload a CSV, text, Excel (.xlsx) or PDF file of up to 5 MB. The file is read at once, and the payment is looked for.
Review a remittance
Open a remittance to see its Lines and the payment it was matched to. The Status tells you what to do.
| Status | Meaning |
|---|---|
| New, Ready | Stored and read; waiting for its payment |
| Needs Review | A person must act. The Note says what is missing |
| Matched | The payment is found and has a suggestion |
| Applied | The suggestion was accepted |
| Ignored | Not remittance advice, or ignored by a person. The content is kept |
| Failed | The remittance could not be read |
When the customer is unknown, choose the Customer No. and then Find Payment. When the lines are wrong, correct them and choose Find Payment. Read Again reads the stored content again, and View Original downloads it. Match Suggestions opens the suggestions of the matched payment.
PDF remittances
A PDF remittance is stored with the status Needs Review, for a person to key in its lines. Then choose Find Payment.
If the PDF contains embedded files, the Note lists them. Choose Download Embedded Files on the remittance to get them as a ZIP file. Then upload an embedded CSV with New from File.
Good to know
- The customer is found by the sender's email address or by the invoice numbers in the remittance.
- Amounts in the email body are read in US format, such as 1,250.00.
The Remittance Inbox Log report lists the remittances of a period with source, sender, customer, status and matched payment.
What's next
Hold customers who are too far overdue: Credit holds.