P&L Report: Expenses don't tally

1

The expenses portion of my P&L report do not tally. I’ve added comparative columns to show June, July, Aug, etc. For example, without listing the detailed line item, the major sections show:

                  June         July          Aug
Staff         (3638.00)    (55,700.00)  (24,212.00)
Operating     (1989.27)    (2,550.07)    (2,594.08)
Marketing      (489.76)    (2,637.90)    (2,043.04)
R&D           (1694.88)    (169.00)         0.00

EXPENSES       47,413.32    (36,417.08)    32,952.85

This doesn’t make any sense. Why don’t they tally? And where does the dramatic swing from positive to negative come from?

Thanks!!
Danny

2

You need to post a screen shot of the entire P&L report. Without seeing the structure of your chart of accounts, it’s impossible to understand what you’ve transcribed. Obscure organizational information if necessary.

Also post a screen shot of the setup screen for this P&L report, showing the column names and from/to dates.

3

Hi,

I’ve attached the PDF of the report with test data and a screen shot of the setup is below…

Thanks!

4

Can you post a screenshot of your entire P&L Chart of Account structure from Settings - Chart of Accounts.

5

If you attached it, it did not make it into your post. Only the setup screen shows. We need to see the resulting report.

6

The forum will not allow PDF to be uploaded.

778×184 10.9 KB

7

Then use a screenshot of the report prior to PDF creation or take a screenshot of the PDF report itself so that it is a jpg/jpeg just like your screenshot of the P&L setup shown above.

8

Here’s the Chart of Accounts for P&L (three pics) and the offending report.

To reiterate my question, the expense numbers don’t add up. For example June shows (3,638.00) + (1,989.27) + (489.76) + (1,694.88) = +47,413.32

Thanks
Danny

273×846 39.1 KB

230×631 23.4 KB

351×842 46.1 KB

643×784 78.9 KB

9

Your Expenses (7) is currently subtotalling Revenue & Expenses, that is why your expense figures are in brackets (negative income) and your Expense subtotal is showing a profit.

You need to group the Expenses separately from the Revenue - I will go and build the model and come back.

10

From the guide on building a chart of accounts:

“Interim subtotals and final totals are useful in accounting displays. Add them with the New Total button. Totals calculate a running summation of all groups above them in the chart of accounts.”

11

207×528 16.6 KB
205×512 10.4 KB

Note: the accounts that are underlined are “New Total”

You don’t have to create totals for group heading as they automatically create there own totals.

12

Hi there,

Yes, that fixed the tally error. Thanks!!

Danny