I believe this is related to Opening Balances
To elaborate a bit more on having entries for months without any records, you need to LEFT JOIN your existing dataset with a table containing all dates - so the the resultant dataset will also contain all dates. This is the only way to achieve this with Pivot Tables since these do not support populating missing dates automatically. (Line charts should support the option to fill in date gaps).