Skrooge: Order of Operations on same Date


I was wondering whether it’s possible to fine-tune the ordering of operations in Skrooge at all.

I import the data for all my accounts into Skrooge - often an arbitrary CSV format specific to that institution is the only lowest common-denominator many banks give me, but sometimes I am lucky enough to get Quicken/Microsoft Money, with more fields, which are maybe not affected in the same way.

I need to report the maximum amount of money I have had in each of my accounts, and this is one reason I use Skrooge. Not uncommonly, I have several operations in one day. My problem is that the ordering that operations come up in Skroooge sometimes does not match what happened in the real world.

As a typical example, let’s say I move a large amount from one savings account to another via my main current account. So this current account has a large deposit and then a large withdrawal on the same day. However, when those are exported from my bank’s online banking, they only mark the day, and not a full timestamp, so Skrooge is perhaps none the wiser.

If the withdrawal comes before the deposit in Skrooge, then it looks like my account has gone overdrawn temporarily on that day. Whereas, if the operations happen in the opposite order, then the balance in my acocunt matches what I get if I check my PDF statement in online banking.

So I was wondering if there is any way to specify the order of operations in a more fine-grained manner in Skrooge at all. I don’t know if there is a real solution to this problem, as it stems from rubbishy access to my data from my banks, or my own imperfections in cleaning the data as part of the import process. If ther’e s a fix for this, then great, would be appreciative of any suggestions. Maybe I can add a synthetic timestamp before I import the data that ensures it goes into Skrooge’s database in the right order, even if this isn’t displayed in the operations window.

However, I am happy to correct it manually for now, but it would be good if I could e.g. drag the operations or add a time field or somehow otherwise mark them manually to occur in the correct order within Skrooge, so that subsequently when I export that account’s data, the balance column is calculated correctly. Otherwise, it’s of limited use to me for this specific exercise, as I’ll always need to go through the PDF copies month by month and verify the amount in the balance column.

I don’t know if Skrooge has this kind of ability - either in the data schema or in the UI. Is there some way to add more refined ordering to items in an account, if they occur on the same calendar day?


1 Like