Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
January 1, 2019
Question

Thirteen 4 week accounting period for restaurants?

  • January 1, 2019
  • 5 replies
  • 1 view
Anybody knows how to do this is QB..Unlike the typical 12-month calendar, the 13 4-Week accounting cycle consists of 13 accounting periods of exactly 4 weeks (28 days) which complements the weekly cycles used in many restaurants and provides for more relevent period comparisons on the profit and loss statement.

5 replies

Moderator
January 1, 2019

Hello there, @linajanehayden.

 

Welcome to the Community. I'm here to help and walk you through in generating a 13/4- Week Profit and Loss (P&L) report. 

 

In QuickBooks, you can view your periodic financial statements in any time period format you wish, especially your P&L. To generate a 13-four week accounting periods, you'll need to customize your P&L report.

 

Here's how:

  1. On the left pane, select Reports
  2. Find and select Profit and Loss in the Find report by name field.
  3. Set the date range to define the four-week period.
  4. Click Run Report.  

The following article contains additional information about this, as well as the steps for saving your customized reports: How to customize reports.

 

For additional help, feel free to reach out to our Customer Care support. They have the tools that can help you get to a resolution quickly. 

 

Here's how:

  1. In your browser, navigate to https://help.quickbooks.intuit.com/en_US/contact.
  2. At the top right, select your QuickBooks version.
  3. Select a topic.
  4. Click the Get Phone Number or Start a Message button. 

These resources should help to get you back on track.

 

Thanks for dropping by. Feel free to click the Reply button if you have any other questions about generating a 13/4- week accounting cycle report. I'll be happy to help you further. 

 

September 23, 2020

If you are running 13 four week periods, how do you set up budgets for 13 periods?

Moderator
September 23, 2020

Hi there, @Kenflip61.

 

Budgeting in QuickBooks Online was designed to only create budgets for 12 months, quarterly, and monthly intervals. 

For now, the option to create a budget by four weekly intervals for 13 periods is unavailable in QuickBooks. 

I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.


Also, you can ask your accountant for further advice on how you can allocate your budget using the available intervals in QBO. 

In addition, you can run some special budget reports that will help you in tracking your budgeting goals. Here's how to access them:

 

  1. Go to Settings ⚙ and click Budgeting.
  2. Find your budget on the list.
  3. Select the Action ▼ drop-down arrow and click Run Budget Overview report or Run Budgets vs. Actuals report.

 

If you have further questions or concerns, feel free to reach back out anytime. Have a great day and stay safe.

January 11, 2019

Hi Lina,

 

I've been away from community for a while, but happened to spot your question today.  I've been doing restaurant books for over 20 years... and frankly my constant search is for a good solution to this problem.

 

Here are a couple of tips -

1.  There are a few apps that work with QuickBooks online that specialize in reporting.  I personally use Futrli, which allows me to report on a fortnight (2 weeks) for some items.

2.  A friend/colleague Angela Meharg of Datisfy has been developing a way to satisfy some elements of these requirements by using budgeting features and some other neat tricks..

3.  If you are on Facebook, please join us over at Restaurant Accounting Network.  This closed group has a lot of people sharing a lot of ideas on how to best do restaurant books.

4.  I would also recommend stating to QuickBooks in every way you possibly can that the ability to customize reporting periods on reports needs to be more robust.  To date, I think their position has been that reporting apps can handle that.  But since most reporting apps take cues/limits on how they can deal with data from the database they are pulling from, it often means they are only set up to riff off of what QuickBooks can do, at best.  

 

***If you are interested, I am doing a webinar next week about how to better streamline the bookkeeping process for restaurants.  There will be a particular focus on making the books reflect what really matters to restaurants in a manner that is actually helpful to them.  Tips on how to customize some stuff will be throughout, including allusions to 13/4 periods etc.  So feel free to reach out to me if you are interested.

 

On a personal note, QuickBooks and other accounting platforms love to use retail and hospitality in advertising.  These businesses are very visual, and frankly come off very authentic.  They typify, I think, everything that is 'small business entrepreneurship'.  

 

It's kind of no secret to anyone who knows me that in my opinion this means that they owe retail and hospitality a product that fits their basic needs! 

 

It's ok if QBO and desktop aren't equipped with the defaults necessary for these industries, but shouldn't they be at least more friendly to customizations that they need?  For instance, do a report on last week and it goes Sunday to Saturday.  Which means weekends are split.  Perhaps a great thing for Monday to Friday businesses, but not the best for retail and hospitality, where weekends mean A LOT.  Such a simple thing....

 

I hope in the coming year Intuit will make an effort to fold in some improved ability to customize the basics (reporting, company defaults, etc.) in their products.  It certainly would help the very business owners whose faces I keep seeing, again and again, helping to sell a product that could be such a better fit!

 

Just my two cents.

Kristen Nies Ciraldo

May 2, 2019

Is your webinar archived and available?

Moderator
May 2, 2019

Hello there, @602352.

 

You'll be happy to know that our archive of previous webinars are still available and I'm glad to share it with you.

 

You can check out this article to view the list of available webinars from February 2017 - February 2019: In the Know Webinars.

 

Please know you can always come to the Community for all of your QuickBooks needs. I'll keep an eye out on your response.

dataurant
April 2, 2019

Great news! This is possible in QuickBooks Online and QuickBooks Desktop/Enterprise. I found an article that can help to explain the details on how to compare custom previous periods: https://quickbooks.intuit.com/community/Help-Articles/How-to-customize-your-Profit-and-Loss-report/m-p/186382

 

The secret sauce to making this more seamless is enabling "QuickBooks Classes" (for Plus or Advanced QBO). Once enabled, a "Class" needs to be assigned to all "Transactions", whether they are Journal Entries, Sales Receipts, Invoices, Bills, Payments, Checks, etc. A QuickBooks Class needs to be created for each account period, and the periods can be named anything you wish. For example, the QuickBooks Class named "Period 1" represents the first accounting period of the year. If you add the "Period 1" class to all QuickBooks Transactions that occur in the first 4 weeks of the year, in all years. Now, when you view the class-based financials, you are in-fact viewing period-over-period financials. Voilà!

October 24, 2019

Thanks for the reply but that doesn't exactly give you the period by period reports I find so useful to pickup on trends and identify when entries are hitting the wrong period.  In 2018 the P&L by four week report worked very well for this.  It was obviously designed to do just what I need it to do.  But they rolled over the four week period start date from 2018 meaning the first week of the first four week period is December 24, 2018.  We added a fifth week to our 13th period in 2018 to get back to close to the calendar year.  It could be solved if they let you set your fiscal year to a start date rather than start month.  but they won't let you do that either.  Thanks for your reply, though.

Morgan_B
QuickBooks Team
October 24, 2019

Hi there, Qdpgh.

 

Thanks for following up on this thread and for the details you've provided.

 

I can see how having the option to set a fiscal year start date, rather than start month would be beneficial. The Development Team is always on the look out for ideas, as many product and feature updates come from great user suggestions like yours. I'll do my part and pass this along to them.

 

You can learn more about functionality that will soon be available to you by viewing our Blog: https://intuit.me/2L2zqTv.

 

Don't forget, you're always welcome here in the Community if you ever have questions. Take care.

September 12, 2019

Most would do this in Excel and a tool like F9 would help automate the data pull from QuickBooks

September 12, 2019

Most would do this kind of report in Excel with a tool like F9 that would automate the data pull from QuickBooks