Profit and Loss Analysis

97 vues Markdown

Money collected against money spent over the same period, with the net between them for every day.

Reaching the Screen

Open WAnalytics from the menu, then pick Invoices › Profit/Loss Analysis in the left rail. The direct address is {admin}/wanalytics/invoices/profit-loss-analysis.

What Is on the Screen

The report title carries an information mark that sums up what it measures. Its controls sit on the same line, and three bands follow underneath.

The controls

All Currencies (Local) Optional; the default. Both sides are converted into your local currency, which carries a star in the list. Pick a single currency and you see only the payments and expenses made in it, without conversion.
Select Date Range Optional. The period behind every number on the page. Left alone it covers the last 30 days.
Apply The circular arrow beside the date box. It runs the report again on whatever period the box holds.
Download as PDF Saves the report as one document. Your logo (when one is set), your domain and the period go on it; the controls stay out.

The figures

Four totals for the chosen period.

Net Income less expense. A loss is marked out; a profit is left plain.
Income Everything collected in the period.
Expense Everything recorded as spent in the period.
Days Length of the period, quiet days included.

Profit/Loss Trend Analysis

All three measures share one plot and one scale, which is what makes them comparable. Income and expense stand as columns, the net runs as a line above them. The legend at the top switches a measure off. A period with no records shows No data available for the selected period.

The daily table

One row per day that saw income or an expense; days with neither stay out. The download button sits above it, and the record count and the rows-per-page selector are at the foot. Click a column heading to sort by it. The search box beside the download button does not narrow this report; use the date range and the currency list instead.

Fields

Table columns

Date The day, with its weekday under it. Newest first until you sort otherwise.
Income Invoices paid that day.
Expense Expense records dated that day.
Net (P/L) The difference for that day. A negative figure is marked out.

Ready-made periods

The date box opens a calendar where you mark a start and an end; the menu beside it offers Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, This Year and Last Year. A quick range applies at once; a calendar pick applies when the calendar closes, and the × mark clears the box.

Tasks

Report on another period

  1. Click the date box in the report header, then pick a ready-made period or two dates of your own.
  2. Close the calendar (click outside it); the page reloads and every figure, plot and row follows the new period.
  3. The period stays in the address, so you can bookmark the narrowed report or send it to a colleague.

Read one currency on its own

  1. Open the currency list in the report header.
  2. Pick the currency you want; the table below narrows to records made in it at once, unconverted.
  3. Click the circular arrow beside the date box so the figures and plot take the same choice.
  4. Go back to All Currencies (Local) for the combined figure.

Find the days that lost money

  1. Click the Net (P/L) heading in the table to sort by the difference.
  2. The worst day rises to the top; the Income and Expense columns beside it say which side caused it.

Take the report out of the panel

  1. Click the Download as PDF button in the report header for the whole sheet, figures and plot included.
  2. For the numbers alone, click the download button above the table and pick CSV, JSON or XML.
  3. The file holds every day of the period, not the page you happen to be looking at.

Things to Watch

The two sides come from different places

Income is read from paid invoices. Expense is read from your expense records, which cover cash management entries, automatic periodic expenses and the refunds booked on a cancelled or downgraded service. A cost that was never written down makes the net look better than it was.

This is a cash view, not an accounting statement

An invoice counts on the day it was paid, an expense on its own date. Unpaid, cancelled and refunded invoices never reach the income side, so the net answers "what moved" rather than "what was earned". An invoice only reaches the income side once it is paid in full, and then its whole amount lands on the day of the last payment; part payments count nowhere until the invoice closes.

Conversion uses the rate of the moment

Under All Currencies (Local) both sides are converted at today's rate, not the rate on their own date. The same period can show a different net next month. Pick a single currency when a figure has to stay fixed.

Required Privileges

The whole WAnalytics section, this report included, needs WANALYTICS. Without it the page answers with an access message and no data. Downloading the table as CSV, JSON or XML additionally needs TABLE_EXPORT; without that one the download button above the table is not shown at all. The Download as PDF button in the report header does not ask for it.

Cet article vous a-t-il été utile ?

Merci pour votre retour !

Besoin d'aide supplémentaire ?

Notre équipe d'assistance est disponible 24h/24 pour tout ce que vous ne trouvez pas ci-dessus.

Nous contacter Ouvrir un ticket

Nous utilisons des cookies pour vous garder connecté, mémoriser votre langue et votre devise, et améliorer le site. Politique relative aux cookies