This Accounts Receivable (AR) report runs using a Point-In-Time logic. Basically this means that the report shows all the invoice balances as they existed on the date entered in the AR Date field. 


A Note on the AR vs. GL Report:

Your marina's accounts receivable when shown on the Accounts Receivable Report and when calculated from the General Ledger Report may sometimes result in slightly different values. This is due to each report using slightly different methodologies for calculating AR when it comes to transaction allocation* behavior.

  • The Accounts Receivable Report (with all checkboxes off) includes allocations where the Transaction Date is on or before the AR Date AND the target of that allocation (receivable invoice) has an Invoice Date on or before the AR Date.
  • In the Molo GL module, allocations affect your AR as of the Allocation Date. The legacy configuration for allocation date is that the allocation is dated on the Allocation Performed Date (or the day the user allocates the payment). As of June 2024, Molo now has new allocation logic that can be optionally enabled by reaching out to Molo support. Molo's new allocation logic sets the allocation date to the date of the invoice or the date of the payment, whichever is greater - OR if both invoice and payment are both in a locked period, it will set the allocation date to the lock date +1.

* for the purpose of this section, allocations refer to allocations of prepayment or security deposit invoices. Allocations of regular payments (aka payment on account) do not affect AR.



When Running Report with Include Deposits Off and Include Security Deposits Off

  • Steps the Report Takes
  • Find Invoice and Credit Note Balances - The report gathers all invoices, and credit notes where the Invoice Date is on or before the AR Date in the report. It then sums all the active line items of those invoices and credit notes to get a customer balance.
  • Find Payment and Refund Totals - The report then gathers all payments, refunds, and payments on account where the Transaction Date is on or before the AR Date.
  • Find Deposit (Prepayment) Allocations - The report then finds all Prepayment Allocations where the Prepayment Transaction Date is on or before the AR Date and the target of that allocation (receivable invoice) has an Invoice Date on or before the AR Date.
  • It then combines the "Invoice and Credit Note Balances", the "Payment and Refund Totals", and the "Deposit (Prepayment) Allocations"


When Running Report with Include Deposits On and Include Security Deposits Off

  • Steps the Report Takes
  • Find Invoice and Credit Note Balances - The report gathers all invoices, and credit notes where the Invoice Date is on or before the AR Date in the report. It then sums all the active line items of those invoices and credit notes to get a customer balance.
  • Find Payment and Refund Totals - The report then gathers all payments, refunds, and payments on account where the Transaction Date is on or before the AR Date.
  • Find Deposits (Prepayments) - The report then gathers all prepayments where the Transaction Date is on or before the AR Date and includes the full amount of that prepayment.
  • It then combines the "Invoice and Credit Note Balances", the "Payment and Refund Totals" and the "Deposits (Prepayments)".


When Running Report with Include Deposits On and Include Security Deposits On

  • Steps the Report Takes
  • Find Invoice and Credit Note Balances - The report gathers all invoices, and credit notes where the Invoice Date is on or before the AR Date in the report. It then sums all the active line items of those invoices and credit notes to get a customer balance.
  • Find Payment and Refund Totals - The report then gathers all payments, refunds, and payments on account where the Transaction Date is on or before the AR Date.
  • Find Deposits (Prepayments) - The report then gathers all prepayments where the Transaction Date is on or before the AR Date and includes the full amount of that prepayment.
  • Find Security Deposits - The report then gathers all Security Deposits where the Transaction Date is on or before the AR Date and includes the full amount of that Security Deposits.
  • It then combines the "Invoice and Credit Note Balances", the "Payment and Refund Totals" , the " Deposits (Prepayments)" and the "Security Deposits".


Other Settings

  • Include Walk-In: If selected, the default contact for POS Invoices, Valued Customer, will appear
  • Run for Entire Company: For Companies with multiple marinas, this checkbox will show the A/R Balances for All Locations. The Marina Name for each contact will appear to the right of the last name in Molo and the Downloaded Report.
  • Use 5 Aging Columns: If selected, this will add an additional column for 'Past 120 Days' balance