How to Quickly Change Orientation of an Excel Table

You may have a list of items going down a column.

For some reason you want to change the orientation to make it go across a row instead.

How can you do that?

It is quite easy actually.
Highlight all the items in the List and Right-Click Copy them.

Then go to any empty cell and Right-Click 'Paste Special...'
Note: Make sure that you allow for enough space for the row to go across. Otherwise your data may be overwritten.

Tick the Transpose Option.

VOILA! Your new list is ready.

Debtor Journal

There are times when you require to post a correcting journal against a debtor account. A common example would be to write off a small amount due to rounding difference or exchange rate difference. You might have a number of transaction lines against the debtor which can be considered 'settled'. Since you can't issue a receipt against it, the alternative way is to use Debtor Journal Program.

From the program, you can post balancing or correcting figures against the debtor and it will update both Debtor Subledger as well as the General Ledger. This ensures that your GL and Subledger remains in balance.

Debtor Ageing

Have you ever wondered why your Debtor Ageing figure doesn't look right? It is probably because you forgot to run the Debtor Month End Process.

Before you run this, you need to make sure that ALL your Debtor Statement has been saved or printed. This is very important since once you run the month end, you will not be able to reprint a back dated Debtor Statement.

After printing/saving all your Debtor Statement, all you need to do is to specify what is the first date of the next month for the Debtor Month End Process.

You can tick Archive Transactions if you want to get rid of all the fully paid lines in the Debtor Statement.

Once you have run the Month End Process, you will see that your Debtor Ageing Report would display in the correct ageing category.