GnuCash搜索妙用

拥有Costco Executive会员,每周都会去购物、加油,每次都得花一百多,多得时候有两三百。但是一直不知道一年在Costco花多少钱。

这两天学习了GnuCash的搜索功能(菜单Edit -> Find),发现搜索结果相当于一个虚拟账户,通过给这个账户生成报表,可以得到数据汇总。

首先尝试一个简单的例子,得出去年在Costco加油的费用,下图是搜索条件,

搜索结果显示在一个虚拟账户标签页,然后通过菜单Reports -> Account Report生产报表,报表最后的Net Change显示去年大概花了一千七百多。

计算在Costco所有消费费用只稍微复杂一点,选中所有费用账户即可,

用同样方法生产报表,Net Change显示费用超过一万!

这个方法有个局限,每条帐目的描述必须包含costco(或costco gas)字样,记录的时候需要留意。

 

加州申报HSA利息和收入

根据Supplemental Guidelines to California Adjustments (FTB Pub.1001)第10页(跟公司里的培训是一致的),

Federal law allows taxpayers to exclude from gross income the interest and dividends earned on HSAs. California does not conform. Therefore, all interest earned and any taxable dividends earned on HSAs are taxable in the year earned. As a result of this tax treatment, the taxpayer has a California basis in the HSA account.

Enter the current year interest earned as an adjustment on Schedule CA, line 8, column C. Enter the current year taxable dividends as an adjustment on Schedule CA, line 9, column C.

一个模糊地带是HSA投资收益或损失是否要报税,网上的讨论也是各执一词,鉴于我有几块钱的损失,决定还是申报一下(需要额外填一份CA Schedule D)。

H&R Block在加州州税申报里根本没有HSA相关的向导,只能手工修改表格。由于H&R Block禁止e-file手工修改过的表格,只好打印出来邮寄,好处是省了$20 e-file费用,坏处是速度慢……