Senior Living Communities

Creating New AP Trial Balance

You can generate an AP Trial Balance report based on invoice date or fiscal period, for specific vendors, and as of a specific date. You can also select the report output format, sort by vendor code or vendor name, print in detail or summary, and show aging buckets.

  1. In the AP Reports section, click AP Trial Balance - New.

  2. In the AP Trial Balance by section, select to generate the A/P Trial Balance by invoice date or fiscal period.

  3. In the Select Vendor by section, select to run the report for just one vendor either by vendor Code or Name. You can also run the report for a Code Range or Group of vendors.

  4. To run the report by Invoice Date, enter the As of date. To run the report for Fiscal Period, enter the fiscal period.

  5. Select the Report Output Format from the list. 

  6. Select the Sort By option. You can sort by Vendor Code or Vendor Name.

  7. Select whether you want to the report in Detail or Summary in the Report Type section.

  8. If you do not want to see aging buckets, clear Show Aging Buckets.

From EMC - Reporting - GL/AP section

  1. In the AP Reports section, click AP Trial Balance - New.

  2. In the AP Trial Balance by section, select to generate the A/P Trial Balance by invoice date or fiscal period.

  3. To run the report by Invoice Date, enter the As of date. To run the report for Fiscal Period, enter the fiscal period.

  4. In the Communities section, select the Include Inactive Communities, if you need to include inactive communities for the report. To run the report for specific communities, set the option to Selected Communities and the Communities Selection window opens. Select all the required communities and click Save.

  5. In the Select Vendor by section, select to run the report for just 1 vendor either by vendor Code or Name. You can also select to run the report for a Code Range or Group of vendors.

  6. Select the Report Output Format from the list. The options are PDF, HTML and EXCEL.

  7. Select the Sort By option. You can sort by Vendor Code or Vendor Name.

  8. Select whether you want to the report in Detail or Summary in the Report Type section.

  9. If you do not want to see aging buckets, clear Show Aging Buckets.

  10. Use the print options to print the report.