Excel Accounting Template > Help Desk - Excel Accounting Template > Knowledgebase

Search help:

How do I sort my bank transactions?


When you download your bank transactions you may find your transactions being sorted from newest to oldest.

In the Excel accouting template transactions are entered from oldest to newest.

Follow these steps to sort your bank transactions from oldest to newest:

  1. First, import your bank transactions using one of the import modules
  2. Go to one of the Bank tabs
  3. Now select only the white cells from B10 to Lxxxx (xxxx = last row number containing data)
  4. Then rightclick and choose Custom Sort (last option)
  5. Now choose column E and click OK (make sure to untick 'My data has headers' on the top)
Was this article helpful? yes / no
Related articles How do I record credit card transactions?
How to upgrade to a new version?
How do I install an update?
The account lookup cell is empty. What do I do?
Article details
Article ID: 37
Category: How do I...
Rating (Votes): Article rated 3.0/5.0 (43)

« Go back