Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
kathie5
Level 1

How do I find recurring journal entries that have already been done?

I have a recurring journal that I enter every pay day and a recurring invoice record that I enter every Monday. I do not know how to go back to see previous journal entries. Can you help me with that
9 Comments 9
MichelleBh
Moderator

How do I find recurring journal entries that have already been done?

Yes, sure, @kathie5.

 

Thank you for utilizing our recurring features in QuickBooks Online (QBO). I'm here to ensure you're able to review all the recurring journal entries that have already been done in QBO.

 

You can find the successful recurring Journal Entry in QBO by running a Journal or Transaction Detail by Account report. I'm happy to guide you through the process. 

 

  1. Go to the Reports tab on the left side. 
  2. Type the said report in the search box. 
  3. Click the Customize button. 
  4. Pick a Report period and Row/columns
  5. Select Journal Entry in the Transaction Type.
  6. Tap Run report
  7. Click the transaction one at a time to review the data. 

 

 

For more details about customization, check out this article: Run reports in QuickBooks Online.

 

You can also click the Save customization button to memorize the report. This will help you since it automatically updates every time there are newly added transactions. 

 

I've added helpful articles that surely help you in handling your recurring transactions, journal entries, and reports. 

 

 

Feel free to leave a message below if you have further questions about your journal entries. I'm always here on your back, ready to help you. Keep safe. 

riverside27
Level 2

How do I find recurring journal entries that have already been done?

I want to have a journal report of only those entries created by recurring journal entries and the template name source.  This is to review templates vs results posted.

RCV
QuickBooks Team
QuickBooks Team

How do I find recurring journal entries that have already been done?

Thanks for checking in with us, riverside27. 

 

The option to run a journal report for recurring journal entries and the template name source is unavailable in QuickBooks Online (QBO). We can filter the Recurring Transactions list to see the journal entry template. Here's how:

  1. Click the Gear icon in the upper-right corner and select Recurring Transactions.
  2. Select All in the Template Type field.
  3. Choose Journal Entry in the Transaction Type field.

Then, we can customize the Journal Report to see the journal entries that were created successfully.

  1. Go to Reports and search Journal Report.
  2. Click the Customize button and go to the Filter section.
  3. Select Journal Entry in the Transaction Type.
  4. Click Run report.

 

You can also modify the report by clicking the Customize button. Once you have the perfect set of filters, save them so you can run the same report in the future. Let me show you how: 

  1. After you customize a report, select Save customization.
  2. Give your report a name.
  3. Press Save.

 

To learn more about this one, see the Customize reports in QuickBooks Online article. Using the Transaction Detail by Account report would be a good alternative, too. Also, use the Search menu to pull up a journal entry list: How to Print a Journal Entry Report.

 

Feel free to visit our Reports page for more insights about managing your financial reports in QuickBooks. 

 

I'm just one post away if you need a hand with reconciling your accounts or any QuickBooks-related. I'll be here to ensure your success. You have a good one. 

riverside27
Level 2

How do I find recurring journal entries that have already been done?

I could not find any option in Customization to add a column or reference that the journal was sourced from a recurring entry, nor what the recurring entry template name was.

 

I want a journal report of:

1) posted recurring entries only.

2) a column referencing the recurring journal entry template name (I know there is a field linking this because if I make a change to the posted journal entry it asks if I also want to update the template).

 

ReymondO
Moderator

How do I find recurring journal entries that have already been done?

Hi there, @riverside27.

 

The option to view a recurring template list that shows all the recurred transactions is unavailable in the program.


For now, you can two separate reports and compare its data to track these records in QuickBooks. 

You can run the Recurring Template List Report to view all of your posted recurring templates in QuickBooks Online. All you have to do is filter the report's Transaction Type to Journal Entry to see its list. Here's how:

 

  1. Go to Reports and search for Recurring Template List report.
  2. Click Customize, then filter the Transaction Type drop-down list to Journal Entry
  3. Select Run report.

 

Then, you can run another report to view all of the journal entries that were made in the program. 

 

  1. Go to Reports and search Journal Report.
  2. Click the Customize button and go to the Filter section.
  3. Select Journal Entry in the Transaction Type.
  4. Click Run report.

 

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.

You can also visit our Firm of the Future site. This is where we share recent happenings and future developments, such as updates to newly added features.

To add up, here are some resources that you use when handling reports in QuickBooks:

 

 

Should you have any follow-up questions or concerns, don't hesitate to post again here in the Community or leave a comment on this thread. Take care and have a good one.

riverside27
Level 2

How do I find recurring journal entries that have already been done?

Not good. I should be able (via a query, GL report or similar source) to distinguish posted journal entries sourced from a recurring template vs. from journal entries not from a recurring template.  I know the link is there, but now I know not available to the user.  Please add this as a request as a desired feature improvement.

CharleneMaeF
QuickBooks Team

How do I find recurring journal entries that have already been done?

Your voice matters to us, riverside27.

 

I can see how the functionality to view recurring template lists on other available reports would be beneficial to your business. With this, I'd recommend sending a feature request directly to our Product Development team. This helps us improves your experience with the program. 

 

Here's how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.

 

For your visual reference, I've attached a screenshot below.

Capture.PNG

Also, you can track feature requests through the Customer Feedback for QuickBooks Online website.

 

Additionally, I've added these articles that'll help you learn more about running and customizing reports in QuickBooks Online.

 

I'm only a few clicks away if you need assistance running and personalizing reports in QuickBooks. It's always my pleasure to help you out again.

Anienoel
Level 1

How do I find recurring journal entries that have already been done?

I have created a recurring journal entry for prepaid expenses, monthly. How do I use it again? It isn’t the same as the standard recurring bill. Thanks for your I assistance. 

ChristieAnn
QuickBooks Team

How do I find recurring journal entries that have already been done?

Hello there, Anienoel.

 

I'll be sharing further details on how recurring transactions work in QuickBooks. Let me also ensure you can use the created journal entry for prepaid expenses in QuickBooks Online again.

 

Bill and journal entry transactions are distinct and they work differently and independently in the program. However, they're still the same in how they work when it comes to organizing recurring transactions. The program allows you to specify the Type to ensure that the entry occurs at the appropriate time.

 

For you to utilize again the created recurring journal entry for prepaid expenses, I recommend choosing the Use option in the said transaction. Before doing so, you have the option to open the template and set up it as Scheduled if you need this entry apply to monthly basis.

 

 

Here's how:

 

  1. Click the Gear icon ⚙.
  2. Choose Recurring transactions.
  3. Locate the recurring journal entry and click the Edit link. 
  4. Go to the Type drop-down arrow and select Scheduled.
  5. Click Save template.

 

Once done, please follow these steps on how you can use the template again:

 

  1. Go to Gear icon ⚙.
  2. Select Recurring transactions.
  3. Choose the template. 
  4. From the Action column dropdown menu, select Use to utilize the template as a starting point for a new transaction.

 

In case you need steps on how to permanently delete a journal entry that isn't needed anymore in your business, you can read this article: Reverse or delete a journal entry in QuickBooks Online.

 

If you have additional concerns regarding creating recurring journal entries, please leave a reply under this thread. I'll get back to make sure you get the assistance you need, Anienoel. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us