Information about Manual Totaling on the Business Activity Statement in Microsoft Dynamics GP


Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

INTRODUCTION


This article describes Manual Totaling on the Business Activity Statement, how to control it, and how it affects the tax figures reported in Microsoft Dynamics GP and Microsoft Business Solutions – Great Plains 8.0.

More Information


The Business Activity Statement (BAS) is the tax return form that is used in Australia to report the Goods and Services Tax (GST) figures to the Australian Taxation Office (ATO). The ATO allows two calculation methods for the tax collected and tax paid as shown in fields G9 (GST on Sales) and G20 (GST on Purchases) on the GST Calculation Sheet. The field M (Use manual totaling) on the GST Calculation Sheet is used to show which of the two methods has been used.

Description of methods

Method 1: Use Manual Totaling

With Manual Totaling, the BAS processor code sums up the tax amounts from the individual transactions. Then, the values are manually totaled for fields G9 (GST on Sales) and G20 (GST on Purchases) on the GST Calculation Sheet.



Manual Totaling is the recommended method because it is the most accurate. This method directly relates to the source transaction data.



Note when you use Manual Totaling, when you divide the value in the G8 field (Total sales subject to GST after adjustments) by 11, it may not equal the value in the G9 field (GST on Sales). In addition, when you divide the value of the G19 field (Total purchases subject to GST after adjustments) by 11, it may not equal the value in the G20 field (GST on Purchases).



This is typical, and is frequently caused by a combination of rounding errors and partially taxed transactions, Reduced Input Tax Credit (RITC) transactions, or transactions taxed at a non-standard rate (not 10%).

Method 2: Use Divide by 11

The Divide by 11 method sums the total transaction amount including GST for sales and purchases that are subject to GST, and then divides these amounts by 11 to obtain the estimated tax component of these transactions.



The tax amounts for fields G9 (GST on Sales) and G20 (GST on Purchases) calculated in this manner are estimates and will not be as accurate as the Manual Totaling method.



Note the GST rate is set to 10%. The following example shows how the divide by 11 rule is implemented:

Tax ratio =Tax Rate % / (100% + Tax Rate %)
10% / (100% + 10%)
10% / (110%)
1 / 11

To display the GST Calculation Sheet, follow these steps:

  1. On the Reports menu, point to Company, and then click BAS Report to open the main Business Activity Statement Report window.
  2. Select a BAS Report Option which has been processed. A list of process run dates and times will be displayed.
  3. Click a process run, and then click Open to open the Edit Business Activity Statement window.

  4. Click the expansion button to the right side of one of the following fields to open the Edit GST Details window:
    • 1A (GST on sales or GST installment)
    • 1B (GST on purchases)
  5. Click the expansion button to the right side of one of the following fields to open the Edit GST Calculation Sheet window:
    • G1 (Total sales)
    • G10 (Capital Purchases)
    • G22 (Estimated net GST for the year)


    On the lower left corner of the GST Calculation Sheet is the M (Use manual totaling) field. This will show whether Manual Totaling has been used for the current process run.

How to start using or stop using Manual Totaling

  1. On the Reports menu, point to Company, and then click BAS Report to open the main Business Activity Statement Report window.

  2. Select a BAS Report Option, and then follow the appropriate step:
    • If a BAS Report Option exists, click Modify.
    • If no BAS Report Option exists, click Add.
  3. Modify the Report using Tax Collected & Paid amount processing option:
    • Leave the Report using Tax Collected & Paid amount check box selected to use Manual Totaling.
    • Click to clear the Report using Tax Collected & Paid amount check box to stop using Manual Totaling.

    Changes to the Report using Tax Collected & Paid amount check box will take effect the next time that the BAS Report Option processed.

References


For more information about how to handle reduced-input tax credits in the Business Activity Statement reporting tool in the Australian version of Microsoft Dynamics GP, click the following article number to view the article in the Microsoft Knowledge Base:

934694 How to handle reduced-input tax credits in the Business Activity Statement reporting tool in the Australian version of Microsoft Dynamics GP

For more information about why transactions are missing from the Business Activity Statement (BAS) for Australian GST, click the following article number to view the article in the Microsoft Knowledge Base:

945198 Information about why transactions are missing from the Business Activity Statement (BAS) for Australian GST in Microsoft Dynamics GP

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.