Profit and Loss for 52/53 Tax Year Data Model

Modified on Sat, 6 Jul at 11:56 PM

Overview of the QuickBooks Profit & Loss 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 FIELDS

DIMENSION DETAIL LINKS

Dates and Calendar Dimensions:

NONE

Document Based Dimensions:

NONE

List Based Dimensions:

Linked Information:

NONE