AR Transaction Report

Financial Statement | AR Transaction Report | Accounts Receivable

AR Transaction Report

AR Transaction Report Menu

AR Transaction Report refers to the list of detailed customer's invoice

Requirements before using AR Transaction Report

• The user should setup have the following records in order to proceed on using the AR Transaction Report
  1. Customer
  2. Accounts Receivable
  3. Receipt Voucher

AR Transaction Report Terms on Oojeema Prime System

Field	Description
1. Record Filter(Date Range, Customer)	Provides a set of filter options for precise searching of records. The Date Range is automatically set for the current month The Customer is automatically set to filter all
2. Export	Allows the user to Export the Records into Spreadsheet
3. Customer Code	Reference Code for customer record. The set of Customers and Customer Code can be seen in Customer Maintenance Module. Customer Codes is a unique field on Customer Maintenance Module, thus, it cannot be edited once created.
4. Customer Name	The Customer Name affiliated to the Customer Code. Customer Name can be edited in Customer Maintenance Module.
5. Voucher Number	Reference Number of a specific Accounts Receivable.
6. Payment Voucher	Reference Voucher used to pay the Accounts Receivable. In most cases, Receipt Voucher is used
7. Transaction Date	Date when the Voucher was created.
8. Invoice No	Reference No. of the source transaction of the Accounts Receivable The Reference No can be a Sales Invoice or Billing Transaction
9. Amount	Total Amount of the Receivable
10. Amount Applied	The Total Amount paid for the Receivable (It can be partial or whole)
11. Balance	The remaining Balance after computing the Total amount less the Amount Applied.
12. Remarks	Any information or notes applied in the specific Receivable,
13. Terms	the set default days on the customer for them to pay their outstanding balance on their receivables If terms are not set in Customer Maintenance Module, the due date will be automatically set 7 days after the transaction Date
14. Status	The current status of the Voucher used in the Receivable (It can be Posted/Open/Cancelled)

Notes:

• Customer Status must be ACTIVE in order to check its status in the AR Transaction Report.
  • Customer Records can be seen in Customer Maintenance Module

Filtering and Exporting AR Transaction Report

1. Click Reports under Main Menu
2. Under Reports page, click AR Transaction Report under Financial Statements section
3. Under AR Transaction Report, click the Export Button on the right side. Take note that the user can filter the date and the customer for precise exportation of records.

Viewing Vouchers on AR Transaction Report

1. Click Reports under Main Menu
2. Under Reports Page, Click AR Transaction Report under Financial Statement Reports.
3. Under AR Transaction Report, Check the Voucher Number Column, you will see the voucher list with links for a specific date. Click on the voucher number to redirect you to the View mode of the selected Voucher.
   • The user may receive payment while viewing an Accounts Receivable record.
   • The user may tag Profit Center while viewing an Accounts Receivable record.
     • They may only tag a Profit Center if the Accounts Receivable is not yet Posted.