Chris Travers wrote:
The GL and COA reports are accurate. The tax collected bug was discovered by a customer of mine back in SQL-Ledger 2.4.x. I believe it is meant to show what invoices have what sorts of taxable items on them. This is different from the tax collected. My thinking is that it would be good to simply relable things so that this is clear and keep the current report as is.
I think I read that this report has just been removed from SQL_L (with some sarcastic reason) ?
I don't know that I would call it a "trick", but what I found helpful was to introduce a "VAT Control" account which is my end of quarter accrual (UK requires payment of sales taxes on a quarterly basis). So I track VAT paid and earned as seperate ledgers, then clear these down to zero at the end of each quarter (based on trial balance report, plus a manual glance at the transactions report). Then I can simply enter my VAT return based on this entry. As an aside this also makes it simple to record the payment of sales tax (which may have a timing difference), by recording the payment from the control account
Happy to flesh this out on the wiki. I think it would be helpful for us non-accountants to have a useful bag of resources somewhere on how to enter many of these transactions. For example I also recently (finally) figured out how to enter in multi-currency entries into SL and it's actually quite simple... Will write it up shortly
Ed W