The AR Postings Report lists every transaction posted to and from an Accounts Receivable account for a selected date range, grouped by Company or Travel Agent.

Overview

The AR Postings Report shows transactions that have been posted to and from Accounts Receivable (A/R) for a selected date range. It is used by the accounts team to check what was transferred to A/R in a period, and to identify transfers that were later voided. The report is built per Company or per Travel Agent, and the output is titled A/R Posting Analysis.

Each row is one transaction posted to or from an A/R account. Transactions are grouped under the Company or Travel Agent that holds the account, with a subtotal after each group and a Grand Total for the whole report.

Please Note! This report only shows transactions that have been posted to the A/R. It does not include A/R receipting. To see receipts and running balances on an A/R account, use the AR Statements Report.

Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.

Before building the report, ensure the following:

• The user has access to the AR Postings Report through their Security Profile.
• Accounts Receivable is enabled and the Companies or Travel Agents being reported on have an A/R account.
• Charges have been transferred to A/R in the period being reported on. See Invoice to Accounts Receivable (A/R or AR).

Use Cases

• Reconciling a period's A/R transfers - at end of month, the accounts team builds the report for the month to confirm which charges were transferred to A/R and which were voided.
• Investigating a disputed Company balance - build the report for a single Company to see every posting made to and from that account, with the reservation and invoice number for each.
• Checking Travel Agent activity - switch Report By to Travel Agent to review postings made against Travel Agent accounts in the period.
• Finding voided transfers - negative amounts on the report identify transfers that were reversed, so a transfer that was posted and then voided nets to zero.

How to Access

In the side menu of RMS, go to Reports > Accounting > AR Postings.

Tip! Select Schedule instead of Build to have the report generated and delivered automatically on a recurring basis.

Report Options

Tip! Report build screens default to a common use configuration, and selections can be made as required.

Column Headers

The columns below appear on the report output. Rows are grouped under the Company or Travel Agent that holds the A/R account, with a subtotal in the Amount column after each group and a Grand Total for the report.

Data Sources & Calculations

Postings to and from the A/R

A posting to the A/R is created when a Tax Invoice is raised on a Reservation Account that has a Company, Travel Agent or Wholesaler as the Bill To. The account then shows a Transfer to A/R (Debit) entry. See Invoice to Accounts Receivable (A/R or AR).

A posting from the A/R is created when that transfer is voided, which cancels the Tax Invoice and reverses the transfer. See Cancel a Transfer to Accounts Receivable.

Both appear on this report against the same Inv No, the transfer as a positive Amount and the reversal as a negative Amount, so the pair nets to zero in the group subtotal.

Please Note! A group subtotal or Grand Total of zero does not mean there was no activity. It means the postings to the A/R in the period were matched by postings back from the A/R, for example where every transfer was later voided.

Date range

The AR Transfer Between range filters on the date the transaction was posted, not on the reservation's arrival or departure date and not on the invoice date. The range is inclusive of both the start and end dates. The dates used are printed under the report title as From <start> To <end>.

Grouping and sorting

The Report By option sets the grouping level: one group per Company, or one group per Travel Agent. The group header shows the account holder's name. The Sort By option controls the order of rows within each group and does not change the grouping.

Related Reports

• AR Statements Report - produces account statements for A/R accounts, including receipts and running balances.
• Debtors Ledger report - lists outstanding A/R balances by account.
• Unpaid Charges Report - shows individual unpaid charges by A/R account.
• Void Reasons Report - lists the reasons selected when transactions, including A/R transfers, were voided.
• Overdue Invoice List Report - lists invoices that are past their due date.

Related Articles

• Enable Accounts Receivable
• Invoice to Accounts Receivable (A/R or AR)
• Cancel a Transfer to Accounts Receivable
• View All Tax Invoices Raised for a Specific Company or Travel Agent
• Companies in RMS
• Travel Agents in RMS