在 Beancount 中追踪非网络医疗索赔

Martin Blais - 更新时间:2023 年 11 月

让我们通过一个例子来说明如何处理有保险和 HSA 索赔的医疗治疗。以非网络心理治疗为例:治疗费用需先自费支付,之后再获得报销。

当接受一次治疗时,记录为应收和应付项目:

   2023-09-06 * "Dr. Freud" "Session" #freud-2023-09
     Assets:AccountsReceivable:Psychotherapy     260.00 USD
     Liabilities:AccountsPayable:Psychotherapy  -260.00 USD

   2023-09-11 * "Dr. Freud" "Session" #freud-2023-09
     Assets:AccountsReceivable:Psychotherapy     260.00 USD
     Liabilities:AccountsPayable:Psychotherapy  -260.00 USD

随后,支付部分款项以结清应付项目:

   2023-09-12 * "ZELLE SENT" #freud-2023-09
     Assets:US:BofA:Checking                     -520.00 USD
     Liabilities:AccountsPayable:Psychotherapy    520.00 USD

整个月份均按此方式处理:

   2023-09-20 * "Dr. Freud" "Session" #freud-2023-09
     Assets:AccountsReceivable:Psychotherapy     260.00 USD
     Liabilities:AccountsPayable:Psychotherapy  -260.00 USD

   2023-09-23 * "ZELLE SENT" #freud-2023-09
     Assets:US:BofA:Checking                     -260.00 USD
     Liabilities:AccountsPayable:Psychotherapy  260.00 USD


   2023-09-27 * "Dr. Freud" "Session" #freud-2023-09
     Assets:AccountsReceivable:Psychotherapy     260.00 USD
     Liabilities:AccountsPayable:Psychotherapy  -260.00 USD

   2023-09-28 * "ZELLE SENT" #freud-2023-09
     Assets:US:BofA:Checking                     -260.00 USD
     Liabilities:AccountsPayable:Psychotherapy  260.00 USD

月底,治疗师会出具索赔单。我们向保险公司提交索赔,结清应收款项,并将剩余部分转为待签发的保险公司支票:

   2023-09-28 * "Claim for September filed with insurance" #freud-2023-09
     Assets:AccountsReceivable:Psychotherapy  -1040.00 USD
     Expenses:Mental:Psychotherapy              312.00 USD
     Assets:AccountsReceivable:Anthem           728.00 USD

最终,保险公司会出具 EOB(赔付说明),确认实际覆盖金额(本例中为 70%,此比例已在条款中明确),并寄来支票存入银行:

   2023-10-24 * "ATM CHECK DEPOSIT" #freud-2023-09
     Assets:US:BofA:Checking             728.00 USD
     Assets:AccountsReceivable:Anthem   -728.00 USD

此时我们已知可由 HSA 支付的剩余部分金额,因此向 HSA 管理公司提交索赔,再次记录为应收和应付项目:

   2023-10-25 * "HealthEquity" "Filed for reimbursement" #freud-2023-09
     Liabilities:AccountsPayable:HealthEquity  -312.00 USD
     Assets:AccountsReceivable:HealthEquity     312.00 USD

HSA 公司直接将款项存入我们的支票账户:

   2023-11-01 * "BofA bank (Claim ID:1234567-890); EFT to bank" #freud-2023-09
     Assets:US:HealthEquity:Cash               -312.00 USD
     Liabilities:AccountsPayable:HealthEquity   312.00 USD

在银行端导入此交易时,将其记入应收项目:

   2023-11-01 * "HEALTHEQUITY INC" #freud-2023-09
     Assets:US:BofA:Checking                    312.00 USD
     Assets:AccountsReceivable:HealthEquity    -312.00 USD

最终结果是,HSA 资金用于覆盖保险未涵盖的部分费用。

|-- Assets                       
|   |-- AccountsReceivable       
|   |   |-- Anthem                
|   |   |-- HealthEquity         
|   |   `-- Psychotherapy        
|   `-- US                       
|       |-- HealthEquity         
|       |   `-- Cash                  -312.00               USD
|       `-- BofA                   
|           `-- Checking         
|-- Expenses                     
|   `-- Mental                   
|       `-- Psychotherapy              312.00               USD
`-- Liabilities                  
    `-- AccountsPayable          
        |-- HealthEquity         
        `-- Psychotherapy

Net Income: (-312.00 USD)

上述方法存在一些缺陷:

  • 保险覆盖金额通常在事前已知;但在许多情况下,实际金额只有在保险公司出具 EOB(即“赔付说明”)后才能确定。因此,上述流程需要相应调整。