ElyxAI

Excel for a claims handler: which open file still has reserve left

The claims workbook on this page is the list you open before the morning review of open files. One row is one claim. You type the claim, the holder, the type word, the opened date, the reserve, and the amount already paid. Left is reserve minus paid while the row is still open. The window says open-amt when that difference is above zero, settled when the two amounts match, and over when paid is above the reserve you typed. This file is not a policy renewal calendar. That calendar answers which contract date is inside the notice you typed. This list answers which open claim still has reserve above the amount already paid. It is not a supplier invoice register, and it is not a customer collection list. The opened date stays on the row and is not in the money formula. You type the reserve. The sheet does not raise it. The guide below builds that reserve list. Elyx writes the amount left and the window in the workbook you already keep. You still type the reserve and the amount paid. The trial lasts 7 days, with no card.

1 workflows

Frequently asked questions

What goes on a claim reserve list?

One row per claim: reserve, amount already paid, and a window of open-amt, settled, or over.

Is this the policy renewal calendar?

No. A renewal calendar uses a contract date and notice days. This sheet uses the reserve and the amount paid that you typed.

Does the sheet raise the reserve?

No. If paid is above the reserve, the window says over. You retype the reserve yourself. The formula does not change that cell.

Essential
Popular