cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Report on Past Closing Dates

Is it possible to run a transaction report to show past closing dates?   It would appear that our closing may or may not have been done for awhile. I am trying to find out the last time it was closed.  

Solved
Best answer 03-08-2019

Best Answers
Highlighted
Anonymous
Not applicable

Report on Past Closing Dates

Great to see you today, @CSMG,

 

Welcome to our forum. I can share some insights on how to generate your closing date history in QuickBooks.

 

We can pull up a Closing Date Exception Report so you can view current and past closing dates, alongside with the user who set the closing date. This report also displays all transactions that were changed or entered on or before the closing date.

 

Here's how:

  1. Go to the Reports menu.
  2. Choose Accountant & Taxes.
  3. Select Closing Data Exception Report.

You can view the history in the Closing Date History section of the report. Here's a great article I've attached for your reference with closing books in QuickBooks Desktop.

 

Please let me know if there's anything I can do to help. I'm always around to assist you. Have a good day!

View solution in original post

6 Comments
Highlighted
Anonymous
Not applicable

Report on Past Closing Dates

Great to see you today, @CSMG,

 

Welcome to our forum. I can share some insights on how to generate your closing date history in QuickBooks.

 

We can pull up a Closing Date Exception Report so you can view current and past closing dates, alongside with the user who set the closing date. This report also displays all transactions that were changed or entered on or before the closing date.

 

Here's how:

  1. Go to the Reports menu.
  2. Choose Accountant & Taxes.
  3. Select Closing Data Exception Report.

You can view the history in the Closing Date History section of the report. Here's a great article I've attached for your reference with closing books in QuickBooks Desktop.

 

Please let me know if there's anything I can do to help. I'm always around to assist you. Have a good day!

View solution in original post

Highlighted
Level 2

Report on Past Closing Dates

Unbelievable.  I am back into managing the accounting process and looking for things of past not happening.  I appreciate your help.

Highlighted
Level 1

Report on Past Closing Dates

Hello,

I just joined the community as I have just started working with Quickbooks.  I would like to ask a question about Quickbooks for Mac.  We have the 2019 Desktop Pro version.  I noticed there is no information about the last close date in the system.   Also, under Reports --> Accountants and Taxes, there is no report listed called "Closing Date Exception Report."  Are these not part of Quickbooks for Mac?  We came from Quickbooks Desktop 2014 on a Windows system and it had the last close date though I also could not find that report either.  Thank you for any information you would be able to provide. 

Highlighted
Moderator

Report on Past Closing Dates

I appreciate you joining in this thread, ccwt.

 

You may need to create a backup copy of your 2014 company file and restore it to your 2019 version of QuickBooks. For the detailed process, see the steps below.

 

To create a backup of your company file, here's how:

 

  1. From the File menu, select Back Up. 
  2. On the following dialog window, select the folder where you want to store your backup file (.dmg). NOTE: It's a good idea to save backups somewhere other than your main local drive in case of a system failure. If you have a file hosting service (such as DropBox), flash drive or other removable media, you may want to select it here.
  3. When you have chosen, click Start Backup. The name of the backup will be your QuickBooks filename with the date and time the backup completed. You have the option to view the file in Finder.

After that, let's restore the company file:

 

  1. Double click the .dmg file. A new window opens the "Ghost" drive.
    Note: The "Ghost" drive displays the back up of your company file along with your attachments (if applicable).
    undefined
  2. Drag the company file (with .qbXXXX extension) to the folder where you want to store the company file.
  3. Drag the Attached Documents Library folder (if applicable) to the same folder as the QuickBooks company file.
  4. Click the copy of the company file saved on the desired location or go to File > Open Company.

Once the company file is restored, QuickBooks will ask you to update the file. Just click the Update button.

 

To check for system requirements, see the articles below:

 

Regarding the report, you can pull up the Transaction List by Date and filter it to show the Entered/Modified past transactions since the Closing Date Exception Report is only available in QuickBooks Enterprise.

 

It'll be always my pleasure to help if you have any other questions. Just keep me posted in the comment section down below.

Highlighted
Level 1

Report on Past Closing Dates

RoseMarjorieA,

Thank you for your reply.  If I restore from our old Windows computer to the Mac, all our data entered since we converted would be lost, right?  I would prefer not to do that if I can avoid it.  I have been continuing to research information about Quickbooks.  It seems that: 

  1. Entering a close date only prevents data prior to that date from being changed.  We would do that in order to ensure the integrity of prior fiscal year information once we are satisfied that the year is correct. 
  2. Running a balance sheet for the fiscal year is the only way to see what the change in retained earnings is.  Seeing that information is a report function only and it is calculated every time a report is run. 
  3. Since I cannot see the last close date in Quickbooks Desktop Pro for Mac, I should assume that a given fiscal year was closed properly and the system will enforce data integrity once the close date is set.  If I can enter a transaction in a prior fiscal year, then I know that year has not yet been closed. 

Please let me know if I am not understanding things properly.  Thank you again for your reply and for welcoming a newbie into the group. 

Highlighted
QuickBooks Team

Report on Past Closing Dates

You’re data will still remain though you’ve restored a different company file, ccwt.

 

We suggest to create a back up file of both companies for preventive measures. We’ll have to update your windows company file since the conversion process requires us to have the same version for both QBDT for Mac and Windows. You can use our trial links to update your company file from 2014 to 2020. 

 

Yes, you’re correct with your insights. Aside from not letting the closed books be modified, QuickBooks designed it to set your reporting on when is the actual closing date of your fiscal year. 

 

Here’s how to set a closing date:

  1. From the Company menu, select Users and Passwords.
  2. Click Set Closing Date.
  3. Enter a Closing Date and Closing Date Password.
  4. Select OK to close the window.

If you want to know the changes made within you company file, you can always use the Audit Trail report. 

 

You can always reach out to us if you have further questions. Welcome to QuickBooks and the Community family!

Need to get in touch?

Contact us