Credit Card/Checking Tracking

[skydiverjw]

Greetings,

So, I have a credit card and a checking account. I would like to create a simple tracking spreadsheet showing me a True Balance between the both. Currently, my credit line is: $3000.00. I want to create a field that shows me what I've spent on the card, my card payments, and a true balance of both. I have a separate budget for my checking on another worksheet where I'm already pulling the balance from that worksheet to the credit card worksheet.

[6StringJazzer]

I would think you can make a copy of your checking worksheet and use the same format for your credit card (except you don't need a column for check number). The only difference is that your checking balance should be positive and your credit card balance will be negative. You can add them together to get your net balance (which is what I think you mean by True Balance). That is, the net balance is the amount you will have left in your checking account after you pay off the pending credit card charges.

The credit line is not relevant to solving this problem.

If that doesn't seem to answer the question then please make a copy of your file and delete all the date but leave all the formulas and column headers, and attach it so we can get a better idea of what you have in mind. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.