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

How to change order of items in ledger

Hello! 

 

Had a quick question about how to change the order of entries on an account ledger?  I manually enter in the deposits and payments from the bank, and sometimes the order gets out of whack a little with the bank statement for things that occur on the same day, and I would like to be able to drag the entry so that it mirrors the bank statement.  

 

Any ideas how I would do that?

 

Thanks in advance!

1 Comment 1
RaymondJayO
Moderator

How to change order of items in ledger

Hello there too, @lenaraiwa

 

It looks like we've seen each other in the Community yesterday regarding your foreign currency account's ledger. I'm happy you're back, and I've got some ideas on how to achieve your goal. 

 

We can use the Sort by feature to change the order of entries in your account's ledger. There are seven options you can select from there: 

  • Date, Type, Number/Ref
  • Amount (largest first)
  • Amount (smallest first)
  • Number/Ref
  • Order Entered
  • Date and Order Entered
  • Cleared status

 

For example, I used the Amount (largest first) option, and my transactions start from the highest amount to the lowest one. View the screenshot below for your reference. 

SortByOptions.PNG

 

If the seven options above don't meet your preferred order, I'd suggest exporting the account's QuickReport to Excel. Then, manually drag the entries so they'll mirror your bank statement. I'll guide you how.  

  1. Open the account's ledger/register again. 
  2. Select QuickReport
  3. Set the Dates and Report Basis
  4. Choose Create New Worksheet from the Excel drop-down list. 
  5. Click Export
  6. Manually arrange the transactions based on your preferred order. 

 

The screenshot below shows you the second to fifth steps. For more information, check out this article: Exporting Reports To Excel From QuickBooks Desktop (QBDT)

ExportAccountQuickReportToExcel.PNG

 

Also, you can go to the Help menu, select New Features, and click What's New. This way, you'll learn more about our product enhancements from there. 

What'sNewInQBDT.PNG

 

Lastly, I recommend customizing the Register QuickReport to get the specific information you need for your business. You can also print it to serve as your hard copy. 

 

I'm here anytime you have other concerns. Take care always. 

Need to get in touch?

Contact us