Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Accounting Journal Problem

I am trying to keep an accounting journal in LibreOffice Calc. The format was originally a .xls that was sent from my Accounting professor which I am now attempting to use for my personal use. Basically my goal is to be able to input my transactions in any order and then sort by date. This is so that I will not have to worry about sorting the physical receipts by date and can just let them build up and then dump them all the data into Calc and then sort it out. However, my problem is that each journal entry takes up three rows and I don't know how to sort it without having the journal entries broken up. I've searched around the internet for some solutions on Excel, and they all seem to come down to using the IF/THEN function to generate the appropriate identification for each row and then sorting it by the new row. Every time I try in Calc however, all I can generate is the same number for every row.

This makes more sense if you see it so I have attached an example. If you know of any easier way I could format it, please let me know.

Thanks in advance for your help.

P.S. Please note that Column A is not part of the journal but rather my attempt of coming up with a way to sort the entries.

Accounting Journal Problem

I am trying to keep an accounting journal in LibreOffice Calc. The format was originally a .xls that was sent from my Accounting professor which I am now attempting to use for my personal use. Basically my goal is to be able to input my transactions in any order and then sort by date. This is so that I will not have to worry about sorting the physical receipts by date and can just let them build up and then dump them all the data into Calc and then sort it out. However, my problem is that each journal entry takes up three rows and I don't know how to sort it without having the journal entries broken up. I've searched around the internet for some solutions on Excel, and they all seem to come down to using the IF/THEN function to generate the appropriate identification for each row and then sorting it by the new row. Every time I try in Calc however, all I can generate is the same number for every row.

This makes more sense if you see it so I have attached an example. If you know of any easier way I could format it, please let me know.

Thanks in advance for your help.

P.S. Please note that Column A is not part of the journal but rather my attempt of coming up with a way to sort the entries.