Sub-Account For Bills

btg.19's Avatar


30 Jan, 2019 04:19 AM

I get Paid weekly, (Thursdays) before switching to money dance, Paying my major bills monthly would mean taking a certain amount from each check in order to spread it out so its budgeted to where I'm not using one whole check on one bill.
So as an example Ill use my car payment.
I have my paycheck transaction on Thursday,01-31-19.
Car Payment is $448.35
I divide this into 3 payments per check, $149.45/ check.
Kinda like an envelope system how would I make a sub account (BILLS) reflect this. (just my bill money)
I was thinking of making a sub account for bills and creating a transaction reminder for the amount on each Thursday to be allocated to that account but in reality still be in main (CHECKING) Parent account. The only concern I have with doing this is my bank statement not showing the correct balance because of it just being an allocation account.
I have exhausted trying to transfer my money into another checking account so it reflects the true amounts in my bill account and my checking account for budget purposes.
Can anyone just give me an explanation on how I should handle this correctly with out confusing myself and making it simple.
and how I should document a transfer to my bill sub account (IN) for saving the amount and also (out). And by out I mean my car payment gets taken out of my checking account, So how would recording this transaction work?

Showing page 2 out of 2. View the first page

  1. 31 Posted by btg.19 on 07 Feb, 2019 10:02 PM

    btg.19's Avatar

    Im trying to use the calendar to auto commit a day before, and then when the transactions download the next day i just merge them. Because the way im budgeting for my bills i have to pull from my Jan-31 paycheck, due to my major bills being due usually the middle of the month.
    So i have (2) transaction reminders for my paychecks, ( 1 for each account).
    On the same day as my paychecks in calendar view, below it, I have a transaction reminder of the remaing amount i need for this week,(ive calculated all my bills and divided the total amount by check).

  2. 32 Posted by mhoggie on 07 Feb, 2019 10:12 PM

    mhoggie's Avatar

    Just a user

    Sounds like you are headed the right direction . Once you have all your bills and income set up as reminders you can use the forecast extension to see if things balance out as you expect

  3. 33 Posted by btg.19 on 07 Feb, 2019 11:51 PM

    btg.19's Avatar

    Yes, Ive been playing around trying to come up with a solution for the categories instead of the transfer categories, Im thinking I just create new categories for these bills ,or the sub account process. But then it also showing on my budget for bills ,Correctly that is.

  4. 34 Posted by mhoggie on 08 Feb, 2019 01:28 AM

    mhoggie's Avatar

    just a user,

    You are starting to figure it out now. Most don't realize how useful it is to create custom categories. It's much better than using tags. For instance if you want to budget a loan or credit card payment (mortgage tracking is a bit different), all you do is create a special category like "Car loan payment", then when you set up the reminder, you add a split to the categories to not just show the normal payment to your loan account that you would have set up on MD, but also the same amount to the "car loan payment" category, then another "null" category to offset the additional split so your total transaction will just be the payment amount. Then you can pick up the activity on your budget by using the "car loan payment" category. Mortgage payment budget tracking is similar, but you have to use a holding account or extra reminder because the mortgage reminder will not let you split categories.

  5. 35 Posted by btg.19 on 08 Feb, 2019 08:41 PM

    btg.19's Avatar

    yes thats exactly what im trying to impliment here but so far no luck.
    Right now i just have an account with 2 weeks worth of bills But the total amount says i have more like 3 weeks worth of bills.
    I wish there was an easier way to manage bills using the mixed interval budget. Ive tried it and read the directions but i just cant seem to understand how the date works and why it wont show me week to week and month to month

  6. 36 Posted by mhoggie on 09 Feb, 2019 05:10 PM

    mhoggie's Avatar

    just a user,

    are you setting the budget items as monthly, weekly, or a mix.
    I've never used the weekly budget, just monthly. So not sure what the budget bars look like. I might play around with situation you have and see what MD does.
    Of course, the main thing is to have just enough money in your bill payment checking to easily cover bills as they arrive. MD budgeting is more a past tense view.

  7. 37 Posted by btg.19 on 11 Feb, 2019 04:58 PM

    btg.19's Avatar

    Right now i have 2 budgets one for weekly so i know how much money ive allocated in the account after each check. but thats not working out, So the next one i have made is a monthly bills tracker, And for this one its a mixed interval old, But im working on setting up to begin the last week of each month and end on the 3rd week of the next month Since i have to take money from my last check of the month the 1st check of the next month and 2nd check in order to clear my self for bills the whole month. Any tips on what i could be doing wrong?
    Im just trying to set up a budget that shows the money being allocated. As of right now ive tried everything to help me with this and nothing is working. The only thing thats working is the transfer to the account but even then there is no way im allocating the money, I just have to know in my head every week the balance should stay at a certain amount every week. And its difficult for me to just know with out seeing physical numbers so i may be putting 287$ in my bill account, but the next week i need to have, $287+287=$574, with no budgets i cant divi out what i already have to what t goes to and thats what i wanna see, "
    So a break down basically
    when i have $574- really means
    1-$250 car payment
    2-$178- car ins
    3-$96- ortho

  8. 38 Posted by btg.19 on 11 Feb, 2019 05:07 PM

    btg.19's Avatar

    I think the tricky part is not being to add categories to deposits or transfers. Like my work deposits 287$ in my bill account. How do i add these indivdual amount to specific categories like ortho , Car ins, Car payment, so that way in budget it would reflect that the first week i have 150$ allocated to my car payment, 89$ is for my car ins, and 48$ is for my ortho.

  9. 39 Posted by dwg on 11 Feb, 2019 08:43 PM

    dwg's Avatar

    Deposits are categorized.

    Are you saying that your employer pays specific amounts for things like car ins, car payments etc? Or are you just saying that you have an amount from your wage going to a specific account which is then used to pay certain bills?

  10. 40 Posted by mhoggie on 11 Feb, 2019 11:11 PM

    mhoggie's Avatar

    Just a user,

    What is the primary objective that you want MD to help you track?

  11. 41 Posted by dwg on 12 Feb, 2019 02:01 AM

    dwg's Avatar

    My person opinion is that it sounds like this setup is becoming far too complicated. Simple is best, makes it easier to track and maintain, and keeping the software in line does not become the major objective and task.

  12. 42 Posted by mhoggie on 12 Feb, 2019 02:19 AM

    mhoggie's Avatar

    just a user,

    I agree, you have to focus on what your trying to accomplish. You can get way to caught up with software in and outs and end up spending a lot of time for nothing.

  13. 43 Posted by btg.19 on 12 Feb, 2019 05:16 PM

    btg.19's Avatar

    Thank you,
    Yes I agree with keeping it simple. The only thing I am trying to track are my major bills.
    I have another checking account(bills), where my employer splits my check weekly and deposits the amount of ($287) into that account and the remaining is deposited into my main account.
    ($287) is the weekly amount I need for my 3 bills mentioned.
    But imt trying to budget the actual current amount in this account and what its going too. so lets say week 2 is here I should have ($574) in this account. IF I were to split this total amount i could write it all out on paper and determine how much is saved for each bill so week t2 for example would include:
    300- car payment
    178- car ins
    88- ortho payment
    so I just was able to see how much goes to what based on the total amount.
    Since I do get paid weekly. Im trying to be able to track just the money for bills each month so when have the amount for lets say whren why car is due I can just pay it with out a doubt that ill run into issues with other bills because MD- budget would have told me what money is in the account and whats it is allocated to. and if I was one payment or check away from my car payment ill know in the beginning of the month. not when the payment is due. I don't think its complicated for bills. I already have a budget going for my monthly living expenses so thats no problem. Its just allocating money based on transfers. You mentions deposits are categorized and while yes thats true, For what im trying to use it for its not. Because the ($287) thats direct deposit is my salary , So how would I categorize these for my bill amount budgets? If its already categorized as a deposit. Ive tried to balance the transaction as a wash, so 287 in and 287 out to all of the certain budgets but it ends up just saying $0, and ive tried the sub account idea but That is complicated. IF I could just figure out a way to know what the total amount in this amount allocated per category and not a total amount is my end result. I hope this clarified and Thank you all again for your tips and insight I really appreciate it !

  14. 44 Posted by dwg on 12 Feb, 2019 08:07 PM

    dwg's Avatar

    You are now talking about using envelope budgeting a different budget system where you maintain "pots" of Money for various purposes.

    For the basics of how to do something like that look at:

    Also look at the Moneypie extension

  15. 45 Posted by btg.19 on 13 Feb, 2019 03:03 PM

    btg.19's Avatar

    Thanks, Yes i believe i read this article already and i tried it as well, But I dont Really know how to reconcile my account i just enter the transactions nightly and then on paydays the downloaded transactions that are there i just confirm them or merge them and then they are marked cleared.
    I tried to set up the sub accounts for each major bill but i just didnt think it was that easy seemed more complicated to me, thats why i was just trying to use categories and a budget for this. Right now im looking into more ways other then the envelope way to keep track of allocated money in one account.
    i will look into money pie today thank you!

  16. 46 Posted by btg.19 on 13 Feb, 2019 03:04 PM

    btg.19's Avatar

    If you have any questions for me that will help you get a better understanding of what my situation is feel free to ask. :)

  17. 47 Posted by btg.19 on 13 Feb, 2019 04:17 PM

    btg.19's Avatar

    Right now ive got Transaction reminders, For my bill amount , into there categories Weekly car,weekly car ins, weekly ortho these are the allocated amounts that eaqual to $287, The issue im having with this option (although it does work for what i need) it subracts it away as if its a payment being made when the transaction is split into its categories not actually leaving the account. So the money is allocated in my budget but when it comes to my ledger, My online bank at the end of the 3rd week when i pay bills It says i have $861 but the same account in money dance doesnt reflect that because its taking the money away when the transaction is entered shich really sucks?
    anyone have any other way they can recommend?
    All i really need that is of importance is to know where my money is and what it goes to before it leaves my account. Or to know what money is allocated to what when i see the amount allocated is there ill log on and pay it with no doubt the money was tracked per the checks i receive.

  18. 48 Posted by mhoggie on 13 Feb, 2019 05:00 PM

    mhoggie's Avatar

    just a user,

    can you post a screen shot of your budget setup ?

  19. 49 Posted by TJ Finlinson on 25 Feb, 2019 02:57 AM

    TJ Finlinson's Avatar


    You might like to look at the Money Foresight Extension. This uses the transactions reminders that you have set up to give you a pretty good view of your money in different accounts. I currently use it to help me with forecasting my balance in an account I use only for paying bills. You can look at a table view of your reminders which takes into account the current balance of the account. I think it's a pretty good way to track your spending on bills and to make sure you have enough for those bills.

    I've been using moneydance since 2010, and I like the software, but am hoping that Moneydance will eventually build a true envelope budgeting system to use for budgeting and spending money. Until then, I use the extension and also asset accounts to mimic an envelope budgeting system. This allows me to allocate funds to the asset accounts and then I can categorize my spending to those asset accounts. The only drawback to this is that the the positive and negative amounts are switched. This is the only way that I could figure out how to make it work with tracking the transactions and assigning them in the bank account.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac