Profit and Loss by Class for 52/53 Tax Year Data Model

Modified on Sat, 6 Jul at 11:55 PM

Overview of the QuickBooks Profit & Loss by Class for 52/53 Year Data Model

Traditional Profit and Loss Standard data model, for businesses with specific week needs or who follow the IRS standard for 52/53 Tax Year. This capability is not available inside of QuickBooks.


36 Periods controlled in the QQube Configuration Tool for these calendar types:

  • 4-4-5
  • 4-5-4
  • 5-4-4


39 Periods controlled in the QQube Configuration Tool for:

  • 13 x 4


Features

  • Aggregated by Month for up to 40 Periods across three years
  • 182 Pre-Calculated Measures including column arrangements not possible in QuickBooks
  • DAX measures for Power/Pivot and Power BI
  • Flexible Reporting Periods
  • Excel Add-In contains Presentation Clean-Up Tool


Output Examples

  • Traditional Profit and Loss for IRS defined 52/53 Tax Year
  • Shortcuts for automating updating in Excel, e.g.  Period # in Quarter or Year, etc.
  • Compare Actuals and % of Sales


Schema

AVAILABLE FIELDSDIMENSION DETAIL LINKS

Dates and Calendar Dimensions:

  • NONE

Document Based Dimensions: 

  • NONE

List Based Dimensions: 

Linked Information: 

  • NONE

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article