Trial Balance Report

The Trial Balance Report is used to reconcile the Payables account in Broadcast to the General Ledger.  It retrieves billings, cash disbursements and cash receipts for a given accounting month against a specified Payables account, and shows the balance of the Broadcast Payables account for each owning company/office as of the beginning of that month. Billing or paying activity must occur in the requested month of the report.

In order for the Trial Balance Report to balance with other month end reports in Media Accounting a separate report is run for every calendar month where activity has occurred for this account.

For example, a report must be generated every calendar month from the inception of the account or the correct balance will not be displayed in subsequent reports. Any balance from the previous calendar month only carries over if a report was run on a previous calendar month. The results for the month in this case would balance with the Billing vs. Payments Report.

If you are using Dual Costing, note that this report shows the Net Billed based on the vendor cost in order to show the actual amounts that will be updated to the payables account.

To request a Trial Balance Report, select Media Accounting | Broadcast Media Accounting | Trial Balance Report.

Trial Balance Report Window

1. Key the Payables Account to be reconciled. The report retrieves only clients with this payables account, which is specified in the Client Billing Profile.

2. Accept the of the current month/year in the Accounting Month/Year field or key the month/year for which bill or paid data is to be retrieved.  

3. Key or Lookup the Media or select the All Media check box.

4. Key or Lookup a Client, Client Group, or select the All Clients check box.

5. Use the Close the Month check box to indicate how you want to handle the requested Accounting Month.

   Keep in mind that an accounting month cannot be requested until the previous accounting month has been marked as closed.

   • Selected - Indicate that the accounting month requested has been closed and the balance forward should be captured.

   • Blank - The accounting month requested has NOT been closed.

6. To limit the data to a specific disbursing company/office, key or Lookup the Disbursing Co/Off fields.

7. If you signed on using a corporate account, you'll see the Include All Co/Off check box.

   • Selected - Include all owning company/offices on the report.

   • Blank - Include only clients owned by the corporate company/office on the report.

8. Complete the necessary fields in the Report Formatting Options section.

9. Click the Submit button.

10. Click the Reports icon in the MediaBank A|V toolbar to display the View Spool File window where you can access your report.

Sample Trial Balance Report