Spreadsheet tracking my payments of medical bills

%3CLINGO-SUB%20id%3D%22lingo-sub-2307133%22%20slang%3D%22en-US%22%3ESpreadsheet%20tracking%20my%20payments%20of%20medical%20bills%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2307133%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20some%20help%20with%20how%20to%20start%20a%20spreadsheet%20to%20track%20my%20medical%20bills%2C%20and%20the%20payments%20I%20have%2Fmade%20and%20the%20amounts%20being%20made%20each%20month.%20So%20I%20have%20a%20running%20total%20balance%20to%20count%20down%20to%20zero%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20if%20that%20makes%20sense.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ELisa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2307133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2307750%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20tracking%20my%20payments%20of%20medical%20bills%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2307750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1040802%22%20target%3D%22_blank%22%3E%40Lisa_Winn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20very%20simple%20spreadsheet%20where%20you%20can%20enter%20the%20date%2C%20a%20description%20of%20each%20transaction%2C%20the%20amount%20of%20debit%20or%20credit%20(billed%20or%20payed%2C%20respectively)%20and%20the%20running%20balance%20owed%20will%20be%20calculated.%20%3AMake%20you%20entries%20in%20the%20yellow%20background%20cells%3B%20the%20pinkish%20will%20calculate%20for%20you.%20If%20you%20reach%20row%20100%2C%20you'll%20need%20to%20extend%20(by%20copy%20and%20paste)%20the%20bottom%20row%20before%20you%20add%20any%20data%20to%20it.%20Copy%20and%20paste%20down%20as%20far%20as%20you%20need%20to%20go%20for%20another%20period%20of%20time.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1619715181084.png%22%20style%3D%22width%3A%20690px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276868i14AD73E2D45176B9%2Fimage-dimensions%2F690x340%3Fv%3Dv2%22%20width%3D%22690%22%20height%3D%22340%22%20role%3D%22button%22%20title%3D%22mathetes_0-1619715181084.png%22%20alt%3D%22mathetes_0-1619715181084.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need some help with how to start a spreadsheet to track my medical bills, and the payments I have/made and the amounts being made each month. So I have a running total balance to count down to zero?

 

Please, if that makes sense.

 

Thank you,

Lisa

2 Replies

@Lisa_Winn 

 

I've attached a very simple spreadsheet where you can enter the date, a description of each transaction, the amount of debit or credit (billed or paid, respectively) and the running balance owed will be calculated. :Make you entries in the yellow background cells; the pinkish will calculate for you. If you reach row 100, you'll need to extend (by copy and paste) the bottom row before you add any data to it. Copy and paste down as far as you need to go for another period of time.

mathetes_0-1619715181084.png