--- title: "GST Purchases Report" canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31100138/GST%20Purchases%20Report" format: markdown --- The GST Purchases Report provides the necessary figures to complete sections G10 to G20 on the BAS with an option to print detail. This report categorises the Purchases into GST Paid, GST Exempt, GST Free, Input Taxed, Capital and Undeducted Acquisitions. To p rovide the necessary figures to complete sections G10 to G20 on the BAS with an option to print detail, perform the following: 1. From the ProStix Main Menu select ' Accounts Payable ' then ' Reporting ' then ' GST Purchases Report '. 2. To allow for the GST Purchases Report there are GST Tax Codes in the G/L Chart of Accounts (From the ProStix Main Menu select 'General Ledger' then 'File Maintenance' then 'Chart of Accounts'). The appropriate Tax Code must be allocated against the relevant G/L Accounts used for Acquisitions prior to running this report to ensure the correct information is extracted to the correct areas on the report. Note: It is not necessary to code accounts that are not used for acquisitions or acquisition accounts that are GST taxable]. on the 'GST' field brings up a full list of codes: Allocating the GST Tax Codes To allocate the GST Tax Codes, perform the following: 1. From the ProStix Main Menu select ' General Ledger ' then ' File Maintenanc e' then ' Chart of Accounts '. 2. Select the Company you would like to allocate the codes for. 3. Select the account to be allocated with the GST Code and select . 4. across to the GST column and enter the relevant GST Code and select . (Search) is available if required. Once the GST Codes have been assigned against the relevant G/L Account Codes the Reports are ready for use. Printing the GST Purchases Report To print the GST Purchases Report, perform the following: 1. From the ProStix Main Menu select ' Accounts Payable ' then ' Reporting ' then GST Purchases Report '. 2. Select the company for which the report will be generated. 3. Type the period to report on. Note: The date range must be for a full accounting period. If an invalid date range is keyed an error message is displayed: 'Sorry cannot report on a partial period'. 4. Type 'Yes' to print invoice details during the nominated period. 5. Select the output for the report and select . GST Purchases Detailed Report If a detailed report has been selected, detailed information is printed for Creditors Purchases, G/L Purchases and any Settlement Discounts – GST Adjustments that were processed during the selected period in addition to the BAS Worksheet: Refer to Attachment A. for an example of the Detailed Report. BAS Worksheet If a detailed report is not selected, the report summary provides a BAS Worksheet as shown below. All these figures can be used to prepare the right hand side of the calculation sheet on the Business Activity Statement. Reconciling the BAS Worksheet using the Detailed Report Refer to Attachment A for the examples of figures used in the above BAS Worksheet. G10 Capital Acquisitions. This figure of $1,800 is derived from the total value of Capital Purchases, if you look at Attachment A, Page 1 (Creditor Purchases), there is an amount of $300 being reported in Total column for Capital, if you then look at Page 2 (G/L Purchases) there is an amount of $1,500 being reported in the Total column for Capital, add these two figures together and they should equal what is being reported in G10 on the BAS Worksheet. Formula: Total G/L Purchases Capital + Total Creditor Purchases Capital = G10. G11 Other Acquisitions. = Total value of all other Purchases other than Capital (note: inc). To reconcile this amount back to the detailed report you need to 1 - add the total amounts being reported in the Amount column for G/L Purchases + Creditor Purchases + Other Purchases (note: include GST paid total for Other purchases only). 2 - then minus the total Not Reported amounts and total Capital amounts being reported for G/L Purchases + Creditor Purchases + Other purchases. Note: (this has changed since Sept 03). Formula: Total Amount minus Total Capital minus Total Not Reported = G11. G12 Total Acquisitions. This figure is derived from the total of G10 + G11. G13 Input Taxed. This figure of $2,000 is derived from the total value of Input Taxed Purchases or Transactions, if you look at Attachment A, Page 1 (Creditor Purchases), there is an amount of $2,000 being reported in the Total column for Input Taxed, this total should equal what is being reported in G11 on the BAS Worksheet. Formula: Total G/L Purchases Input Taxed + Total Creditor Purchases Input Taxed = G13. G14 GST Free. This figure of $444 is derived from the total value of GST Free Purchases, if you look at Attachment A, Page 1 (Creditor Purchases), there is an amount of $444 being reported in the Total column for Tax Free, this total should equal what is being reported in G14 on the BAS Worksheet. Formula: Total G/L Purchases Tax Free + Total Creditor Purchases Tax Free = G14. G15 Non Deductible. This figure of $1,200 is derived from the total value of Non Deductible Purchases or transactions, if you look at Attachment A, Page 2 (G/L Purchases), there is an amount of $1,200 being reported in the Total column for Non Deductible, this total should equal what is being reported in G15 on the BAS Worksheet. Formula: Total G/L Purchases Non Deductible + Total Creditor Purchases Non Deductible = G15. G16 Total Non Creditable. This figure of $3,644 is derived from the total of G13 + G14 + G15. To reconcile this amount back to the detailed report look at Attachment A, Page 1, there is an amount of $444 being reported in the Total column for Tax Free, an amount of $2,000 being reported in the Total column for Input Taxed, now look at Page 2, there is an amount of $1,200 being reported in the Total column for Non Deductible, you need to add all these figures together and this figure should match what is being reported in G16. Formula: Total Tax Free + Total Input Taxed + Total Non Deductible = G16. G17 Total Creditable. This figure of $3,063.20 is derived from the total of G12 (Total Acquisitions) minus G16 (Total Non Creditable). To reconcile this figure back to the detailed report look at Attachment A, Page 1 (Creditor Purchases), there is an amount of $4,527.20 being reported in the Total column for Amount, now look at Page 2 (G/L Purchases), there is an amount of $3,200 being reported in the Total column for Amount, add these two amounts figures together which will give you a total of $7,727.20, now look at Page 1 again and subtract the total from the Not Reported column of $520, then subtract the total from the Tax Free column of $444, then subtract the total from the Input Taxed column of $2,000, now look at page 2 and subtract the total from the Not Reported column of $500 and then subtract the total from the Non Deductible column of $1,200 and you should get a total of $3,063.20. Formula: Total Amount minus Total Not Reported minus Total Tax Free minus Total Input Taxed minus Total Non Deductible = G17. G18 Adjustments. This figure of $25.19 is derived from the total value of Settlement Discounts – GST Adjustments processed for the selected period, if you look at Attachment A, Page 3 (Settlement Discount – GST Adjustments), there is an amount of $25.19 being reported in the Total column for Discount, this total should equal what is being reported in G18 on the BAS Worksheet. Formula: Total Discount = G18. G19 Total Credits + Adjustments. This value of $3,038 is derived from the total of G17 (Total Creditable) minus G18 (Adjustments). G20 Total GST Credit. This figure is based on one eleventh of G19. To reconcile this figure back to the Detailed Report look at Attachment A, Page 1 (Creditor Purchases), there is an amount of $142.09 being reported in the Total column for GST Paid, now look at Page 2 (G/L Purchases), there is an amount of $136.36 being reported in the Total column for GST Paid, you need to add these two figures together which will give you a total of $278.45, now look at Page 3 (Settlement Discount-GST Adjustments) and there is an amount of $2.29 being reported in the Total column for GST Adjustment, you need to subtract this adjustment amount of $2.29 from the total GST Paid amount of $278.45 which will give you a total amount of $276.18. Formula: Total GST Paid minus Total GST Adjustment = G20.