Balance at a date

Tips & Tricks for more effective use of AceMoney & AceMoney Receipts
Post Reply
Daezyl
Posts:1
Joined:Sat Sep 15, 2018 7:55 am
Balance at a date

Post by Daezyl » Sun Sep 16, 2018 4:24 am

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

User avatar
RLebeau
Posts:274
Joined:Tue Jan 08, 2013 2:45 am
Location:California, USA
Contact:

Re: Balance at a date

Post by RLebeau » Wed Sep 19, 2018 8:20 pm

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.
Remy Lebeau
Lebeau Software

User of AceMoney since 2004.

whall3y
Posts:5
Joined:Thu Oct 24, 2019 11:23 am

Re: Balance at a date

Post by whall3y » Tue Jan 07, 2020 9:03 pm

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.

User avatar
RLebeau
Posts:274
Joined:Tue Jan 08, 2013 2:45 am
Location:California, USA
Contact:

Re: Balance at a date

Post by RLebeau » Wed Jan 08, 2020 1:21 pm

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.
Remy Lebeau
Lebeau Software

User of AceMoney since 2004.

whall3y
Posts:5
Joined:Thu Oct 24, 2019 11:23 am

Re: Balance at a date

Post by whall3y » Sun Jan 12, 2020 2:42 pm

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

Post Reply