Dear All,
I'm posting this to save others the same frustration.
I use Reckon Home & Business for my business finances and use downloads from my bank for all transactions.
The BAS Report does not report any transactions because I don't do invoices and purchases through Reckon, so there are no tax codes on the transactions. It is not possible to put tax codes against transactions directly.
Reckon's solution for the BAS Report is, for every transaction, to split them and record the GST component separately.
I'm not prepared to do this, so instead, I'm doing this:
- Creating tags for all the amounts I need to provide in my BAS. For consulting, these are G1, 1A and 1B.
- Then I'm allocating a tag against all the transactions in my Business Account using these tags above.
- Then I've created a Custom Report for Spending by Category to provide me the transactions. My criteria are: my Business Account only, Business Categories only, last quarter, with the selected tags.
- From there, I export the transactions to Excel and calculate the GST collected on my income and paid on purchases. The GST is 1/11 of the transaction amount. (Reckon doesn't let you add a report column that is calculated from another)
It would be great if Reckon supported businesses that used bank accounts for their transactions, or at least let us enter a Tax Code against each transaction to fit in with the existing reports. Then Reckon could calculate the GST component and save a lot of business owners a lot of time.
I'm posting this to save others the same frustration.
I use Reckon Home & Business for my business finances and use downloads from my bank for all transactions.
The BAS Report does not report any transactions because I don't do invoices and purchases through Reckon, so there are no tax codes on the transactions. It is not possible to put tax codes against transactions directly.
Reckon's solution for the BAS Report is, for every transaction, to split them and record the GST component separately.
I'm not prepared to do this, so instead, I'm doing this:
- Creating tags for all the amounts I need to provide in my BAS. For consulting, these are G1, 1A and 1B.
- Then I'm allocating a tag against all the transactions in my Business Account using these tags above.
- Then I've created a Custom Report for Spending by Category to provide me the transactions. My criteria are: my Business Account only, Business Categories only, last quarter, with the selected tags.
- From there, I export the transactions to Excel and calculate the GST collected on my income and paid on purchases. The GST is 1/11 of the transaction amount. (Reckon doesn't let you add a report column that is calculated from another)
It would be great if Reckon supported businesses that used bank accounts for their transactions, or at least let us enter a Tax Code against each transaction to fit in with the existing reports. Then Reckon could calculate the GST component and save a lot of business owners a lot of time.
-
140 Points
Posted 4 months ago
