"My spreadsheets get so unwieldy though so quickly. I try to combine inventory into them "
KISS
"you'd post copies of your wonderful Excel spreadsheets "
Each business has different needs. KISS. I do not try to combine anything on any one spreadsheet other than my final P&L Statement where all the relevant numbers from my many schedules are incorporated.
A sample P&L statement can be found at this http://www.pierrelebel.com/lists/P&L-sample.htm
For revenue (sales), since I sell in both Cdn$ and US$, I use a spreadsheet with many columns as follows;
- sales in US$ to customers outside canada (zero rated)
- sales in US$ to customers in NS, NL and NB (13% HST)
- sales in US$ to customers in the rest of Canada (5% GST)
- sales in Cdn$ to customers outside canada (zero rated)
- sales in Cdn$ to customers in NS, NL and NB (13% HST)
- sales in Cdn$ to customers in the rest of Canada (5% GST)
It does not matter if you record your sales daily, weekly or monthly. At the end, you simply add up each column, convert the US$ into Cdn$ and you're done! The information can now be used for your GST/HST return.
For expenses, I use several schedules (as outlined on the P&L). Once again, I use different columns for US$, Cdn$, GST paid - converting US$ into Cdn$ at the end of the process.
For purchases, one schedule, again using different columns for US$, Cdn$ and GST paid - converting US$ into Cdn$ at the end of the process.
With the information oulined in the schedules above, you are now ready to move to your P&L and GST/HST return.
It should be noted I do not let PayPal convert US$ into Cdn$ for me. I withdraw US$ into my US$ bank account, avoiding paying PayPal conversion fee.