Tracking Monthly Finance Charges for Overdue Invoices: A Spreadsheet Solution?

  • Context: MHB 
  • Thread starter Thread starter MHamernik
  • Start date Start date
  • Tags Tags
    Charges Finance
Click For Summary

Discussion Overview

The discussion revolves around creating a spreadsheet to track monthly finance charges on overdue invoices. Participants are addressing the setup of the spreadsheet, including the necessary data such as unpaid amounts, aging of invoices, and interest rates, with a specific end date in mind.

Discussion Character

  • Homework-related, Mathematical reasoning, Debate/contested

Main Points Raised

  • One participant requests assistance in setting up a spreadsheet to calculate interest on 13 overdue invoices, specifying the need for monthly tracking and details like unpaid amounts and interest rates.
  • Another participant suggests contacting an accounting firm for help, which is met with frustration from the original poster.
  • The original poster emphasizes that the issue is fundamentally a math problem and expresses dissatisfaction with perceived unhelpful responses.

Areas of Agreement / Disagreement

Participants do not appear to agree on the best approach to the problem, with some suggesting external help while others focus on the mathematical aspect of the task. The discussion remains unresolved regarding the best method to create the spreadsheet.

Contextual Notes

There are indications of frustration regarding the responses received, suggesting that some participants may not fully understand the mathematical requirements of the task.

MHamernik
Messages
2
Reaction score
0
Need to set up a spread sheet that shows interest month by month on overdue payments from several unpaid (or underpaid) invoices.

I have 13 such invoices, their unpaid amounts, aging in days, and the interest rate.

Spread sheet to start from earliest invoice up until 06/14/2019. Thanks!
 
Mathematics news on Phys.org
MHamernik said:
Need to set up a spread sheet that shows interest month by month on
overdue payments from several unpaid (or underpaid) invoices.

I have 13 such invoices, their unpaid amounts, aging in days, and the interest rate.

Spread sheet to start from earliest invoice up until 06/14/2019.
Suggest you contact an accounting firm...
 
It's still a math problem ("Business Mathematics" topic is there for a reason), would appreciate it if you don't waste my time with stupid responses.
 
MHamernik said:
...would appreciate it if you don't waste my time with stupid responses.
Ok. Hope someone else here steps in and helps you. Good luck.
 

Similar threads

Replies
71
Views
16K
  • · Replies 7 ·
Replies
7
Views
31K
  • · Replies 7 ·
Replies
7
Views
4K
  • · Replies 9 ·
Replies
9
Views
4K