Balance at a date

[Daezyl]

Hi there

I used to use a function quite a lot a few years ago and I cant for the life of me get it working again - can someone help me with the correct format?

I like to set CC payments up as monthly bills. Used to be able to set the transfer amount to be the balance on a certain day of the month, so I can see how my current account will be hit.

Format was something like: Balance("Amex", 15)

Now I cant remember the right format for the date so am having to just use Balance("Amex") which obviously is always too high.

Thanks
~D

[RLebeau]

What you showed is the correct format. The available functions are documented in AceMoney's help file, eg:

Balance function

Returns current account balance or past balance according to the specified date or a day.

Syntax:

- Balance("account")
- Balance("account"; "date")
- Balance("account"; day)

account - string, name of the existing account.

date - string, date in the standard AceMoney format that is specified in the International Settings dialog.

day - number, day of a month. This number identified a day of the current month or the previous month if the current day is less that the specified day. This argument is handy when you want to pay off a credit card as specified in the statement, but don’t remember the exact amount and kept using the card past the statement end date, so the current balance is different from the statement balance. In that case just specify Balance("American Express"; 25) if bank period ends on the 25th day of every month.

[whall3y]

I have a defect outstanding with MechCAD on this...

Scheduled transactions using Interest("Account") or Balance("Account")are not automatically posted correctly when they become due. They are posted with NULL amount instead of the calculated amount. The calculation for future transactions works.

[RLebeau]

I have several scheduled bills that use the Balance() and Interest() functions, and I have not noticed the behavior you describe (the only time I ever see NULL appear is when importing transactions from AceMoney Receipts). However, I don't let most of my scheduled bills post automatically, I prefer to post them manually when the transactions actually post to the banks. I have not had any problems with that.

[whall3y]

Indeed, it works fine if you manually post the transaction.... it is the automatic posting that does not work.