Trying to create a monthly billing that needs to be split into 4 sub categories.

BonnieG

Trying to track a monthly bill that needs to be split into 4 sometimes 5 sub categories. This is a private club situation. Monthly payment doesn't match the actual bill as some are prepayments. Tried to use the CC route with little success.

Quicken Harold

Hi BonnieG. Appreciate your question.

If you are transferring money between accounts using splits, when you are adding splits, you can use [brackets] to transfer money between accounts. For example:


Hope this helps. Please let us know if you need explanation on this picture..

~ Quicken Harold.

jacobs

@BonnieG In the split, the Transfer column is the third column; you can select the account to transfer to there, without needing to type the brackets in the category field; it does the same thing, so it's just as matter of which you prefer.

UKR

It might help, if you gave us an example of the kind of splits you have to make, without giving away any personal information.
Are you, for example, making one payment from your checking account to one bank, which in turn splits the payment among several business credit cards for which you only get one monthly statement?

BonnieG

This is not a bank but a private golfing club that breaks down food spent in the restaurant, purchases at pro shop and costs of golfing + a few more which change every month depending on how much we "charge".
I would like to set it up like a CC account with manual entries but am not sure if I can use the "transfer payment to..." under the Transfer Category.

NotACPA

OK, so if I understand, you're receiving this bill from the club ... and want to split it to use multiple categories for the amounts that make up the total of the bill from the club.

Is that correct?

If so, why doesn't a simple transaction that you split to reflect the various categories work?

If not correct, please elaborate.

OR, are you involved  in creating this bill on behalf of the club?  In which case Quicken is a VERY poor tool for this function ... you'd need Quickbooks.

BonnieG

We receive a monthly statement/bill with the charges. The club card is like a credit card where you charge food, pro shop, golf, and the sub categories I am trying to split the total amount due in.
When there is a balance carried forward (Same as if you carry a balance on a CC) The amount of the check paid is different that the Statement so breaking down the check doesn't match the statement/bill.
I am not doing this on behalf of a club. I am a member of this club.
It would be the same as any Country Club membership.

Greg_the_Geek

Why can't you setup your club card as a credit card account? Each charge would be recorded to the correct category in that account. When you make a payment, it would be a transfer from the payment account to the club card account.

Quicken Harold

Hello BonnieG. Appreciate your question.

This is doable in Quicken if the amounts are the same each month.

* Click on "Schedule" on the bottom of the screen.
* Set your first date and every month that you want this to happen:

You would put the total of all the expenses and then split them per category....

Hope this helps. Please let us know if this is what you are looking for or if you have other questions..

Respectfully,
~ Quicken Harold.

BonnieG

Thank you Harold but the charges are different each month depending on our spending.
At this point my question is ....If I set this up as a CC and make the partial payment from my checking account would the "Transfer to.." be considered as a transfer of money from my checking the same as a CC and not interfere with my income?

NotACPA

A Transfer is neither Income nor Expense ... so the answer to your question is YES!

BonnieG

Okay we are almost there.....how exactly should this transfer look in the Categories? In other words just how would I establish a sub category for the club? When I have tried I cannot get it to appear in Transfer but shows as expense and does this double all the charges? I am confused on how to implement this and the help line only explains what can be done but not how to. Thank you

Quicken Harold

Hi BonnieG. Appreciate your question.

If you are transferring money between accounts using splits, when you are adding splits, you can use [brackets] to transfer money between accounts. For example:


Hope this helps. Please let us know if you need explanation on this picture..

~ Quicken Harold.

Greg_the_Geek

BonnieG said:

Okay we are almost there.....how exactly should this transfer look in the Categories? In other words just how would I establish a sub category for the club? When I have tried I cannot get it to appear in Transfer but shows as expense and does this double all the charges? I am confused on how to implement this and the help line only explains what can be done but not how to. Thank you

A transfer doesn't need a category. 

BonnieG

Thank you all for your patience. It was the brackets around where to post the transfer that I needed.

jacobs

@BonnieG In the split, the Transfer column is the third column; you can select the account to transfer to there, without needing to type the brackets in the category field; it does the same thing, so it's just as matter of which you prefer.

BonnieG

Thank you all.