Skip to content
Bitta Apps

Chapter 4 of 8Page 3 of 3

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

  1. Open Bitta Collections Setup and go to the Remittances FastTab.
  2. Choose More ways to collect > Choose Remittance Mailbox and pick the email account. Remittance Mailbox shows your choice.
  3. To read a folder other than the inbox, choose Choose Folder. A blank Remittance Folder Name means the inbox.
  4. Choose Test Mailbox. It reads up to five unread emails and tells you how many it found. Nothing is stored or marked as read.
  5. 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.

Bitta Collections Setup Remittances FastTab with the remittance mailbox settings
The Remittances FastTab.

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:

  1. Stores the body and each attachment as a remittance on the Remittance Inbox page.
  2. 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.
  3. Finds the customer by the sender address, from a contact or customer email, or else by the invoice numbers on the lines.
  4. Looks for a payment with the remittance total within the match window: an unapplied payment, or a line of a payment reconciliation journal.
  5. 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.

Remittance Inbox with two uploaded remittance files matched to payments
Uploaded remittances, matched to their payments.

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.

Remittance card with the customer, the payment and the invoice lines read from the file
A remittance with the invoices it pays.

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.

Next step

Ready to try Bitta Collections?