FRS Reporting

TFB-co-uk · ‎November 05, 2021

Hi,

I'm a newbie dealing with FRS (Flat Rate Scheme) so forgive me if my questions seem obvious!

So I know FRS is only calculated on sales, when setting FRS up in QBO am i correct that ALL expenses/purchases/cheques are set to "NO VAT" and the gross amount is entered (INC VAT)

Is there an exportable report in QBO to establish my clients "deductible expenses" per quarter, to ensure being on FRS is still beneficial to him? I cant find anything other than the "NO VAT Transactions report" which of course, because the value is entered as a gross figure and as NO VAT, it doesnt have the vat analysis (doesnt show what vat would have been able to claim) which means i have to go transaction by transaction and allocated vat if applicable in another column!

katherinejoyceO · ‎November 06, 2021

Hello there, @TFB-co-uk.

Thanks for sharing your concern here in the Community today. You can run the Transaction Detail report to show the deductible expenses for your customer.

Here's how:

Click Reports in the left navigation bar.
Enter Transaction Detail by Account in the search box.
Click Customise in the upper-right hand part.
Click the down arrow for the Report period and select Custom.
Enter your preferred date.
Go to Filter and select All Income/Expense Accounts for Distribution Account.
Click Run report.

Then, customise and use filters to show the details that only matter to you.

Once done, export the report to excel so you can manage the details and achieve your goals.

Please let us know if you have other concerns. The Community and I will be around to help. Keep safe.

View solution in original post

katherinejoyceO · ‎November 06, 2021

Hello there, @TFB-co-uk.

Thanks for sharing your concern here in the Community today. You can run the Transaction Detail report to show the deductible expenses for your customer.

Here's how:

Click Reports in the left navigation bar.
Enter Transaction Detail by Account in the search box.
Click Customise in the upper-right hand part.
Click the down arrow for the Report period and select Custom.
Enter your preferred date.
Go to Filter and select All Income/Expense Accounts for Distribution Account.
Click Run report.

Then, customise and use filters to show the details that only matter to you.

Once done, export the report to excel so you can manage the details and achieve your goals.

Please let us know if you have other concerns. The Community and I will be around to help. Keep safe.

Topics

Training

Community

Resources

FRS Reporting

FRS Reporting

FRS Reporting

FRS

Leaving the VAT Flat Rate Scheme (FRS) - correct procedure

VAT FRS Submission

Import VAT and FRS

FRS on Invoice

Need to get in touch?