Template Mechanics
Claims Research
Weekly Steps
Monthly Steps
Journal Entries
100
Which macro populates the formulas on the activity tab?
Macro 5.1 "Insert Formulas"
100
What is the most obvious indicator that a claim will be coded as a chargeback on the all claims tab?
The item is a debit.
100
Do you need to send the claims file to the opco each week?
Yes, this is important even if they haven't worked the file. This is an SLA agreement that SBS has with each opco.
100
Which macro removes matched "zero balance" items from the reconciliation?
Clear Zeros, monthly steps # 4
100
Which Journal entry is used to write-off matched variances under $50?
Debit memo clean-up journal entry. JE 30501
200
What happens if you do not add a period number in column "A" on the claims tab?
The current period claims do not appear on the activity tab.
200
If you are researching a chargeback claim how would you write the comment on the claims tab? Give an example.
Chargeback-(any example, i.e. repayment, unauthorized deduction, invalid deduction)
200
Who sends the open claims report each week and what day is it made available?
Sandy on Sunday
200
At what point do you run the monthly macros?
The monthly journal entries have been completed and the reconciliation balances to the GL.
200
Between the chargeback write-off and items aged over 180 days which journal entry takes precedence?
Chargeback Items shoud be processed first and then aged items over 180 days
300
Can you make modifications to the claims template? i.e. add new formulas, tabs, or columns
No, tampering with the claims template will interrupt the macros coded into the template.
300
If you cannot locate a claim number from BSCC what is another source that can be used for research?
Imaging system links: Liberty, SWSS, ect. also use POI+SY+200 in AS400 to locate the true vendor.
300
Which macro button is used to lock the activity tab prior to sending the claims file to the opco.
Macro 20 - Protect Sheet
300
What three journal entries are completed at month end?
Opco submitted, Chargebacks short-paid denied, and over 180 days journal entries.
300
Which journal entry requires approval from management to prevent a write-off?
Items aged over 180 days.
400
What can you do if your file is running slow?
Check data>connections>remove all of the connections. and or check to see how many rows are on the "all claims" tab.
400
If an item on the acitivty tab is missing a claim number which tab will the item be listed on for the opco to review? (clue, not the sub-total amount on the exceptions report).
The item will be listed on the "CLaims without claim numbers" tab.
400
What could happen if the steps aren't run in order?
More work could be created by throwing off balances and less items could be matched automatically.
400
Which file is sent to the opco during the final week of the month, and why?
Send the file that is saved in the next period folder. By the time the file is sent to the opco the month is closed. We are showing the finished product.
400
What steps need to be completed after each one of the journal entries is posted?
The journal entries need to be posted in AS400 as completed and the FIGL data needs to be updated in the reconciliation as well.
500
If you notice that your claims payments are out of balance on the "activity" tab describe how conditional formatting is used to resolve the variance.
Conditional formatting can help identify duplicated items on the activity tab. This can help find if an invoice is on the activity tab more than once.
500
If a claim is identified as short-paid exceeding $50 which issue should be used on the exceptions report to categorize the claim?
Chargeback-short-paid over $50
500
What pre-work can be done on Friday each week?
Update the FIGL information for the week, research claims, and complete matching on the activity tab.
500
What communication is required for the three journal entries at month end?
The opco submitted journal entry requires approval from the CFO for net total over $5,000. As for the chargebacks and over 180 days an email is to be sent as a notification to the opco when the net amount is over $5,000.
500
When the opco uses balance sheet accounts on the activity tab in the "opco submitted column" what step should be taken before processing the journal entry?
You should check the account reconciliation of the balance sheet account to verify that the item is open prior to creating the journal entry.
M
e
n
u