How to Review the Profit & Loss Report

The profit and loss table is essential for understanding your business's financial health, helping you assess profitability by comparing total sales revenue against operational costs. By tracking profit and loss, you can identify trends, manage expenses, and make informed decisions to drive growth, ensuring long-term sustainability and success.

1. In ARC navigate to the Forecast tab on the left-hand side of the page.
2. If you have multiple publications select which magazine you want to view the P&L for at the top of the page.
3. Select the P&L tab from the list of options on the top of the page.
4. Locate the white three dots button to the right of the page above the report.
   1. Select the Start Month you want to view in the table.
   2. Select a Total Type
      1. Projected
      2. Collected
   3. Show Sent Agreements
      1. When toggled on, agreements sent 60 days prior to the selected start month will be visible at the bottom of the table with a light blue background.
5. Next to the white button, you can view the table legend that will guide you through indicators on the table. 
   1. Sent Agreements
      1. Gray Background = agreement is currently being sold into
      2. Blue Background = agreement sent within the last 60 days but hasn't been signed
   2. Opt-Outs & Renewals
      1. Yellow Background = agreement will be lost if an opt-out is exercised
      2. Red Background = agreements last month indicating need for renewal
      3. Clock Icon = The first month a client can opt-out and when hovered, the agreement’s opt-out deadline will show. You do not want to use this tool to remind a client of their opt out, but as a way to prepare in case the client exercised the opt-out.
   3. Customer Love & Special Dates
      1. Party Icon = shows a list of special dates for that month. These dates are connected to the contacts of that account and can be added to or edited in the contacts tab of the account.
      2. Heart Icon = shows a list of Customer Love to-do’s for that month will appear. To add a Customer Love to-do, go to an account's detail tab, add a to-do, and select Customer Love as the to-do type.
   4. Ad Value 
      1. Yellow Number  = the invoice has a partial payment applied
      2. Green Number = the invoice has been paid in full
      3. Black Number = the invoice has no payments applied
6. The P&L report will show you a 12 month view of monthly projected revenue.
7. On the left hand side of the report you will see a list of all the current customer accounts that have active current or upcoming agreements and the agreement term start and end month/year. Each box in their row will show the client’s projected revenue for that month.
8. If the client has a credit card icon next to it, that account has a payment profile on file that is set to autopay on the recurring invoice date.
9. Scroll down to see the Total Projected Revenue for each month under the list of accounts.
10. You can factor in projected page count as a forecasting tool to determine production costs. Changing the page count here will not affect the page count in the editorial section. Production costs will include Ad Value % to City Lifestyle, Print, and Distribution
11. At the bottom of the report you can enter any additional expenses you want to track such as your employees, events, taxes etc. When you enter the cost for the expense, you will have the option to autofill the remaining months at the same value if this expense is recurring.
12. The last row will show the total estimated profit for each month taking the projected revenue and deducting all projected expenses.

How to Review the P&L Report

Explore how to efficiently review the P&L report in ARC with these clear instructions.

Go to citylifestylehq.com

1. The Profit & Loss Report

The profit and loss table is essential for understanding your business's financial health, helping you assess profitability by comparing total sales revenue against operational costs. By tracking profit and loss, you can identify trends, manage expenses, and make informed decisions to drive growth, ensuring long-term sustainability and success.

2. Forecast Tab

In ARC click on the Forecast tab on the left hand side.

3. Select Magazine if needed

If you have multiple publications, select which magazine you want to view the profit and losses for at the top of the page.

4. Click "P&L"

Navigate to the P&L section

5. Click here

Locate the button with three dots above the report.

6. Select "Start Month"

Select the start month you want the report to generate from.

7. Select "Total Type"

Select a total type of profit and losses, projected or collected.

8. Toggle on "Show Sent Agreements" if needed

Click the Show Sent Agreements toggle to also include any agreements that were sent 60 days prior to the selected start month.

9. Sent Agreements and Opt-Outs & Renewals

Next to those tools you will see a table legend to assist you while using the report. Sent Agreements will be gray for the issue you are currently selling into and blue if they have been sent within the last 60 days but not signed. Opt-outs and renewals will be yellow indicating the agreement will be lost if the opt-out is exercised that month. Red shows the last month of the agreement or when they will be up for renewal. The clock icon indicates the first month a client can utilize their opt-out and will show the opt-out deadline. We don't want to utilize this to remind clients about their opt-out, but allows you to prepare if they do.

10. Customer Love & Special Dates and Ad Value

Under Customer Love and Special Dates you'll see that the party icon shows a list of special dates for that month. These dates are connected to the contacts of that account and can be added to or edited. The heart icon shows a list of any Customer Love tasks for that month. These are listed in the account's details tab. If the Ad Value number is yellow, there was a partial payment made towards the total ad value. If the number is green the invoice has been paid in full. If the number is still black no payments have been made.

11. P&L 12-Month Revenue

The report shows you a 12 month view of projected revenue. On the left is a list of all current customer accounts that have active or upcoming agreements as well as the agreement start and end date. From there you will see the client’s projected revenue for each month.

12. Credit Card Icon

A credit card icon next to the client name indicates the account has a payment profile on file that is set to autopay on the recurring invoice date.

13. Total (Projected) Revenue

Scroll down to see the Total Projected Revenue for each month under the list of accounts.

14. Projected Production Costs

You can adjust your projected page count to help determine production costs. Production costs include print and distribution costs as well as the percentage of ad value for City Lifestyle.

15. Add Additional Monthly Expenses

At the bottom of the report you can enter any additional expenses you want to track such as your employees, events, taxes etc. When you enter the cost for the expense, you will have the option to autofill the remaining months at the same value if this expense is recurring.

16. Total Estimated Profit

The last row will show the total estimated profit for each month taking the projected revenue and deducting all projected expenses.

This guide covered essential steps to navigate the P&L report effectively in ARC.

Powered by guidde