Buy now and save 90% off today
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
benjisax@live.co
Level 1

Why do all my expenses come with the same date in journal report?.

 
1 Comment 1
jamespaul
Moderator

Why do all my expenses come with the same date in journal report?.

Hello, benjisax@live.co.

 

I'll share the likely reason why your expenses show up under the same date, and help you correct them. 

 

Those expenses are likely recorded under the same date. In this case, you'll want to edit their posting dates to the correct ones. Here's how to do it: 

 

  1. Click the Expenses tab on the left navigation panel.
  2. Find the expense, then click the View/edit link under ACTION.
  3. Edit the Payment date to the correct one. 
  4. Click Save and close.

 

Do this to the rest of the expenses. You can also do the same process for bills, cheques and journal entries. 

 

If you've imported those transactions using an Excel file, then you'll want to undo those transactions to remove them from your books. Next, reformat the dates again from the Excel file. Finally, re-import those transactions as you normally would then add them back to QuickBooks. 

 

To undo the transactions: 

 

  1. Go to the Banking page. 
  2. Click the Categorised tab.
  3. Check the expenses that were categorised.
  4. Click the Undo button. 
  5. Go to the Reviewed tab.
  6. Check those transactions again, then click Exclude.

 

exp1.PNGexp2.PNG

 

Format the Excel file with the correct transaction dates (make sure to import only those expenses you've excluded).  

 

If you need help categorising your transactions, you can check this article: Categorise and match online bank transactions in QuickBooks Online.

 

Looking for a guide to help you reconcile your bank account? This article can definitely help you familarise the process: Reconcile an account in QuickBooks Online

 

I'd be glad to help you again with your expenses. Just let me know what you need to do. Do you have other questions about QuickBooks Online? Post them here and I'll see what I can do.