›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Transactions in src

Maverick100Maverick100
in Excel Workbook
Can transactions entered in the source workbook be in random date order, or do they have to be sequential? Can sorts, line insertions, etc., be done without issue? Thanks.

Comments

  • VidasMatelisVidasMatelis
    In the Source trasaction worksheet, Date, account, transType, etc order is random. Sometimes with out of order dates you might have TEMPORARY incorrect CashBalance calculated that does not impact anything in "Report" workbook. After entering a few out of order transactions, I like to click on Date column dropdown button and sort by date and confirm that displayed CashBalance matches exactly my bank accounts.
    Sorts can be done without any issues.
    Line insertions and copy&paste can sometimes screw up conditional formatting (lots of rules for that in Transactions worksheet) so I always try to simply enter transactions at the end or, if pasting, paste as values.
Sign In or Register to comment.