Journal Entry Reports

This provides a list of journal entry reports regarding flexible campaigns.

The reports are under the menu Analysis -> Journal Entry Reports. Also, user is provided with an excel link to download the data to an excel sheet. User is also provided with a hyperlink to the campaign ids to view the campaign in detail.

List of Campaign Journal Entries

Click the menu list of campaign journal entries and enter the date range. Click the get journals button and the details of journal ids display. This report provides user with a hyperlink to the journal id and with an arrow to view details of each journal.

User can also view the report by the different selection types of campaign id, contract id, financial period, posted date or entry date range.

The excel link contains data to assist user to view all data and manipulate the excel data.

Deferred Campaign Revenue Report

The report produces the deferred revenue for the flexible campaigns based on the product group and the date. This is created based on the journal entries in these campaigns which the system creates once the campaign is confirmed. This is not tied to the billing periods, but to the journal entry periods.

To sort the report by any of the columns displaying on the screen, drag the column title to the top of the screen.

The results will include both columns. User can click the x button next to any of the columns sorted by and this will reorder the records by the one column listed in the header.

Deferred Campaign A/R Report

This report shows the deferred account details for the flexible campaign by the product group and the date.

The report gives the G/L account id and description, the campaign id details, advertiser, original deferred period, total deferred, the prior year billed amounts, and the twelve period amounts.

Deferred Revenue Report by Period

Navigate to the menu Analysis in the advertising module and scroll to the menu Journal Entry Reports -> Deferred Revenue for a Period.

Enter the period and select the option for Order Type Selection to be “Advertising Campaigns Only”, to show only the revenue for the ad orders, or select the option “Exhibition Orders Only” to show the deferred revenue for the exhibitions only or the option “Exhibition Orders and Advertising Campaigns” to show deferred revenue for both options. Then click the option “Get Data”.

The data displays the GL Account information, the order type, the ID, the advertiser, brand, agency, product group, period to which the revenue is deferred, the end period, total amount deferred, the year to date amounts as well as the balance remaining between the recognized and the deferred, the billing currency, exchange rate if not the default currency, and finally the same categories but in the billing currency if it is not the default currency.

You can also drag a column heading to group the data by this column. For example, drag the digital product group column heading and drop it on the bar where indicated by the G/L Account ID and blue x button. The data then will refresh, and display grouped by product group.

You can drag and drop more than one column.