account receivable

  1. N

    Managing Payment table separate from billing, calculating lps on every received payment based on criteria.

    Current Scenarios: My office colleagues are recording account receivable and sales data in sheet4, however, some companies have started multiple payments during the month and it is now difficult to manage them in this format. Action: so I decided to make new sheet for recording payments, which...
    • NaushadAnwar
    • Thread
    • billing collection late payment late payment surcharge lps payments surchage
    • Replies: 1
    • Forum: Excel Questions
  2. N

    Account Receivable aging and Late Payment Fees

    Hello Sirs, i have made this account receivable with aging report...i have following issues relating to formulas: 1) if the company pays during 30 days there will charge no late fees. 2) if the company pays during 60 days the amount will be deducted from previous month balance. 3) if company...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top