Quicken Accounting - Credit Card Transactions Reporting and Expenses

Misc_User

Active member
  • Jun 9, 2018
    270
    88
    28
    I have created and have been using the following accounts in the software.

    - Cash
    - Credit Card
    - Bank Account

    Let's say I order some food via a mobile app and pay using the credit card. Then, I'd add that payment as a "Charge" to that account. Then, If I checked the "Spending", that amount would be included under the "Food & Dining" category. So, whenever I check it, I know how much I have spent on food for a particular time period. Now, Let's assume the total for that category is "10000" including my latest credit card transaction.

    Later, When I made a payment to the "Credit Card", what I'd do is deduct the amount from the "Cash" or "Bank Account" and add it as a payment to the "Credit Card" account. This is where it gets tricky and confusing for me. Let's say the payment is 5000. Now, If I checked the "Food & Dining" category in the "Spending", it would be "5000" after deducting that card payment. Now, what I see is that the money I've spent for the time period is "5000". Not "10000". And as you can see, that's not realistic.

    Could anyone help me on sorting this. Please point out if there any errors in my accounting logic.


    Thanks in Advance!
     
    Last edited:

    U-tag

    Well-known member
  • Nov 18, 2011
    7,281
    4,374
    113
    මම නම් excel එකේ ඔය expense tracking කරන්නේ. ඒක හරි simple. ඔය ඕනේ විදිහට expense ටික categories කරලා summary එකක් එක page එකකට එන්න ගන්නවා. ඔය apps වල ATM Withdrawal දැම්මා ම මාර complicated.

    Apps එපා වෙනවා.
     

    tclanki

    Well-known member
  • Feb 11, 2010
    5,269
    1,058
    113
    how did you setup your accounts in quicken? You need to have Expense accounts in quicken. Credit Cards, Cash Bank accounts must be created as "BANK" accounts.

    If I was you, my transactions would be a General Entry or creating a bill with the relevant expense category. Imagine I brought something from KFC worth 10,000.00. So I would either enter it as a Bill or Create a General Entry crediting to my Credit Card account. When Im making a payment to my credit card, I would use Fund Transfer or another General Entry Debiting my CC and Crediting my Bank / Cash accounts.