Lot allocation reports and GST paid

SUGGESTED

Hello,

We are home builders and am using the lot allocation part of Sage50.

I need to run a report that shows a breakdown per lot of purchases, which I can do, but it shows amounts before GST.  It doesn't include an option to include a breakdown of how much GST was paid.

Can anyone advise me if this is even possible?  I hope so.

Thank you.

  • 0
    I have worked with a custom home builder and never found a need for the H/GST to be included in project reports. The GST is not an expense as it is an input tax credit when filing GST reports. Project reports only track revenues and expenses.
  • 0
    SUGGESTED

    binkyholder said:
    I need to run a report that shows a breakdown per lot of purchases

    binkyholder said:
    Can anyone advise me if this is even possible?

    Yes, there is an 'allocation' report and an 'income & expense' report.

    To report on allocations to any Asset and Liability accounts (or Equity I suppose, haven't tried), you need the 'Allocation' report from Reports | Projects | Allocation.

    The checkbox for [ ] Allow Project Allocations in the account settings for the GST/HST account must have been checked at the time the transactions were entered in order for the project allocation data to have been stored.

    There are exceptions - Receipts and Payments entered separately from invoices cannot be allocated to a Project.

  • 0 in reply to Alwyn
    Thanks for your answer. I'm just a bit confused because when we go to bill the customer for the next draw, I run the lot purchases report detailing all charges and copy to an excel spreadsheet. It would be nice if the gst was included on the report because otherwise we have to enter it manually on the spreadsheet. The customer still owes the GST for their purchases.
  • 0 in reply to binkyholder

    binkyholder said:
    I run the lot purchases report detailing all charges

    binkyholder said:
    It would be nice if the gst was included on the report

    Exactly which report are you running, and from where?   In the Quantum Edition there is an 'Income' report and an 'Allocation report:

    If you look at the Journal Entry report for any entry that has been allocated, was the Sales Tax allocated?  

    If not, it wasn't allocated, and no report is going to show it, and you may need to change the account setting so that data you are entering now will show up when you need the report: