GST Supplement to the BasicBooks User Manual

1. The GST Purchase Journal
2. The GST Sales Journal
3. The BasicBooks GST Reports
- 3.1 GST Sale and Purchase Reports
- 3.2 Preparing the GST Worksheet and Summary Reports
  - 3.2.1 Entering Adjustments for the Worksheet Report
  - 3.2.2 Selecting the Report Period

Introduction to GST Accounting in BasicBooks

GST Accounting in BasicBooks records your purchases for GST Purchase credits and your sales to compute the GST Sales Liability (the tax you owe the government). Reports may be prepared at any time using either the Worksheet or Accounts method for reporting GST. Separate journals are kept for both sales and purchases. This GST manual is a supplement to the complete BasiBooks General Ledger User Manual and contains instructions for using the GST Purchase Journal and GST Sales Journal. For all other BasicBooks features see the BasicBooks General Ledger User Manual.

This Supplement is divided into three parts. The first part is the GST Purchase Journal which describes how to handle purchases to record credits against GST you owe, The second part describes the GST Sales Journal in which you will record sales used to calculate the amount of GST you will owe the government. The third part describes the reports you can use to summarize your GST credits and liabilities.

Note:: The GST percentage rate may be set in the Company File (access from the General Ledger Main Menu) and is set to default to 10%. If your tax rate should change you may edit the Company File and enter the new rate. After saving the Company File the new rate will be used for all GST amount calculations in both the Purchase Journal and the Sales Journal.

1. The GST Purchase Journal

1.1 GST Purchase Journal Menu

From the General Ledger Main Menu select Purchase journal to access the GST purchases functions. Recording your purchases will create a record of all GST you pay on your purchases. This credit will be used to offset the amount of GST you owe the Government for your sales. When you select Purchase Journal the following drop down menu will appear. All the GST Purchase functions are accessed from this menu.

**Figure 1.1:** Purchase Journal Main Menu
$\includegraphics[scale=0.7]{0_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_purchmenu.eps}$

Select all the Purchase Journal functions from this menu. A brief discussion of each option follows:

Create or Edit Purchase Journal Entries - Click this option to access the journal entry and editing function. (See next Section) Entries made in this journal are held here as temporary entries until transferred to the main permanent Purchase Journal. (Next menu item.) As long as entries are held in this temporary journal you may make changes to the entry or delete it.
Transfer Purchase Journal Entries into Permanent Purchase Journal - When entries have been made to the temporary journal and saved if you are satisfied with their correctness you may click this option to transfer the entries from the temporary journal to the permanent journal. NOTE: Once entries are transferred into the permanent journal they can not be changed. You should check and edit your entries, and make any changes you desire, before transferring them to the permanent journal. Entries are held permanently in the Purchase Journal until you request their deletion. After they are transferred to this permanent journal you may post the General Ledger accounts. All entries in the temporary journal will be transferred at the same time.
Post Purchase Journal to Ledger - Select this option when you are ready to post a summary of the entries into each of the General Ledger accounts you have chosen for each entry. Entries can be posted to the General Ledger accounts only one time. The program will not allow double postings. Before posting to the General Ledger Accounts you will have the option to view the unposted entries on the screen by clicking on the sub menu item, View Unposted Entries.
Print Journal - You can print a hard copy of the Purchase Journal either for the Year-To-Date or specific months. When printing the journal you may select the sorting order.
Search the Purchase Journal - This option brings up a window in which you can enter almost any phrase, name, partial name, other words, accounts, or amounts to search for in the permanent journal. You can specify the search to be performed on any column of the journal.

The following sub-sections describe the purchase menu functions in more detail.

1.2 Purchase Journal Entries

Entries in this window are used to create a record of your purchases and the resulting GST credits. Entries are held in a Temporary Purchase journal until you request them to be transferred to the Permanent Purchase journal. You may make changes to entries in this Journal at any time before they are transferred to the Permanent journal. After making entries on the top portion of the window and clicking the OK button the entry will be shown in the bottom part of the window. You may change or delete an entry by clicking on the line for that entry in the bottom window. After completing your entries click on Save Entries to save the Temporary journal. Each time you select the Purchase journal from the main menu any transactions held in the Temporary journal are reloaded into the bottom window and are available for editing or deletion. Once the entries are transferred to the Permanent journal you may no longer change the entries.

**Figure 1.2:** GST Purchase Journal Entry Window
$\includegraphics{1_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_purchjnl1.eps}$

Enter Purchases for GST Credits

This is the GST Purchase Journal entry window. Enter all purchases on this screen for which you want to include in GST Purchase Credit calculations. Entries are required for each box in the window. Scroll up and down or across to see all columns and rows of the journal. Each entry creates one line in the journal. There is no hard limit on the number of line items entered in this journal. However, we suggest you not make more than 20 or 25 entries before saving the entries and moving them to the permanent journal. (Rule of thumb = Don't make more entries than you are willing to re-enter if the computer crashes).

Payment Method - Click the down arrow to see a selection of Payment Methods. This is the method you used to make the purchase. Choices for Payment Method are Check Payment, Cash Payment, Charge Purchase, or Other Payment Type. Selecting a Payment Method causes the Payment Account box to present a selection of the correct General Ledger Account types for recording the purchase. If you select Other Payment Type the Payment Type box becomes active and you can type in whatever explanation you want. Payment Method is maintained in the journal for information purposes only and has no functional purpose in calculating GST.
Payment Account - Double click the Payment Account box to see a selection of available General Ledger accounts that correspond to the Payment Method you have selected. The Payment Account will be credited with the total amount of the purchase, including any GST. The default is payment by check; (This corresponds to purchases made if you keep your books on a cash basis for GST reporting.) When paying by check you must enter the check number. The check number will become part of the banking records and will be included when you run the bank reconciliation program. For payment by check you will select a Bank Checking Account type and for cash purchases, select a Cash account. For Other Payment Type, chose any type of account as needed.
Entry Date - Today's date is the default when no entry has been made. Reset the date as needed. After each entry the date box is set to that entry date to be ready for the next entry. It is very important to set the MONTH part of the date correctly since this determines the accounting period (month) in which the transaction is to be posted in the General Ledger. You can make changes to the date of an entry at any time before it is transferred from the temporary journal to the permanent journal. (Note: If you need to change the month of an entry after transferring it to the permanent journal, before it has been posted to the General Ledger, you may do so by accessing the Postgres table named, ``gstpurchjnl'' directly and changing the column headed, ``fyprd''. If the entry has already been posted to the General Ledger the only way to change the month to which the entry has been posted is by an adjusting entry in the General Journal.)
Seller Name - This is the name of the firm or person from whom you purchased the item. It is maintained in the journal for information purposes only and has no functional purpose in calculating GST.
Purchase Description - This description is for your information purposes only and has no functional purpose in calculating GST.
Total Purchase Amount - This is the total amount of the purchase including GST, if any. This is the amount you have or will pay the vendor for the item you purchase. The Payment Account will be credited with this amount
GST Purchase Type - Select the correct type of purchase according to GST rules. (Capital, Non-Capital, Input Taxed, Private Use, or No GST in Price). If the purchase does not include GST the GST Account and GST Amount boxes will be hidden.
GST Account - For all Purchases with GST in the Price you must make an entry in this box for the account number which you will use to record your Purchase Credits. This must be an GST Paid Credit type account and must be set up through the General Ledger Account Maintenance menu. This entry box will not be available if the purchase is of a type not including GST. This account will be debited with the GST Amount.
GST Amount - The amount of the GST (default 10%) included in the Total Purchase Amount, if any, will be automatically calculated and placed in this box. You may override this amount but the final total of the GST Amount and Net Purchase Amount must equal the Total Purchase Amount. This is the amount of Purchase credits you will carry in the GST Account and claim when you file. This is an asset to you. You should have already set up an GST Paid Credit asset type of account in the General Ledger to record these credits.

The General Ledger entry for all purchases will result in a credit to the Payment Account and debits to the GST Account and Purchase Account. This entry box will not be available if the purchase is of a type not including GST. You may override the GST Amount but the final total of the GST Amount and Net Purchase Amount must equal the Total Purchase Amount. If you change the Total Purchase Amount the GST Amount and Net Purchase Amount will be aoutomatically recalculated when you click the OK button. If you change either the GST Amount or the Net Purchase Amount, you must manually adjust the other amount so that the total is equal to the Total Purchase Amount
Purchase Account - Double click this box to select an account to charge this purchase to. This is usually an expense or asset type account. This account will be posted (debited) with the net amount of the purchase after deducting GST included in the price, if any.
Net Purchase Amount - This is the amount of the purchase after deducting the GST, if any. You may override this amount but the final total of the GST Amount and Net Purchase Amount must equal the Total Purchase Amount.

After you have completed entries click the Save Entries icon at the top of the window. This will save the entries in the temporary journal. If you attempt to exit without saving you will receive an error notice. You may then either save the batch of entries or exit without saving. If you exit without saving, any new or changed entries made in the current session will be lost. Entries from previous sessions will still exist in the temporary journal.

1.3 Transfer Purchase Journal Entries into Permanent Purchase Journal

After you have completed and saved the entries, and checked to see there are no errors or other changes you want to make, you must transfer the entries from the temporary journal into the permanent journal. Once transferred you can no longer access the entries using the journal entry window described above. (You can, however, make changes by going into the Postgres user interface and altering the entries. But, you must not change any amounts in the permanent journal if an entry has already been posted to the General Ledger. In this latter case use the General Journal to make adjusting entries.)

Select the ``Transfer Purchase Journal Entries into Permanent Purchase Journal'' to initiate the transfer. No further action is required.

1.4 Post Purchase Journal to Ledger

Posting to the General Ledger causes unposted entries in the GST Purchase Journal to be summarized into totals for each General Ledger Account designated in your entries and the summarized total is then posted to the respective GL accounts. The Payment accounts will be credited and the GST accounts and Purchase accounts will be debited with the totals of the summarized amounts. After posting, the data base entries will be marked as posted to prevent posting a second time.

**Figure 1.3:** Purchase Posting Procedure
$\includegraphics[scale=0.65]{2_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_postingopts.eps}$ $\includegraphics[scale=0.6]{3_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_postpurchmonth.eps}$

Before posting to the General Ledger you should review the entries scheduled to be posted. Select View Unposted Entries to see the entries you are about to post. When you are satisfied with the entries and are ready to complete posting of the entries select, Post Entries.

Before posting you must select the month for which you want the entries posted. (You may have entries for more than one month in the purchase journal and, for various reasons, may want to post only entries for a specific month.)

Click the drop down arrow to select the month. Click Execute to complete the posting.

1.5 View Journal On Screen and Print Journal

**Figure 1.4:** Purchase Journal Viewing and Printing Options
$\includegraphics[scale=0.65]{4_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_viewpurchjnl.eps}$ $\includegraphics[scale=0.7]{5_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_purchsortopts.eps}$

The Purchase journal may be viewed on the screen or printed on the system default printer.

Selecting either the View Journal or Print Journal options allow you to chose either a Year-To-Date Purchase Journal or a Monthly Purchase Journal for a specific month. After you have selected the type of journal, and the month in the latter case, you may then select the order in which the journal is to be sorted.

Click the radio button by the sort order you want to use and then click the Submit button.

1.6 Search the Purchase Journal

**Figure 1.5:** Purchase Journal Search
$\includegraphics{6_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_purchsearch.eps}$

Setting up a search of the Purchase Journal is a two step process.

Step 1 - Enter the word, characters, numbers, or pharase to search for. The search will locate all occurances of this text without regard to upper or lower case. After entering the numbers, words or phrase to search for click the drop down button in step 2 to see a list of possible data fields to search.
Step 2 - Click the data field to search in the Purchase data base. Searches are performed without regard to upper or loser case. The field searched will be the one you select here in step 2. If the result contians more than one record you may click to continue reviewing the results or cancel further searching.

Click teh Find button to start the search.

2. The GST Sales Journal

The GST Sales Journal works in an identical fashion to the GST Purchase Journal. The menu functions are the sme as for Purchases. The differences are only those required for reporting Sales rather than Purchases. If you have already used the Purchase Journal the Sales Journal will be intuitive. The following sections describe the use of the Sales Journal.

2.1 GST Sales Journal Menu

From the General Ledger Main Menu select Sales Journal to access the GST sales functions. The following drop down menu will appear. All the GST Sales entry function are accessed through this menu.

**Figure 2.1:** Sales Journal Main Menu
$\includegraphics{7_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_salesmenu.eps}$

A brief discussion of each menu option follows:

Create or Edit Sales Journal Entries - Click this option to access the journal entry and editing function. Entries made in this journal are held as temporary entries until transferred to the permanent Sales Journal. (Next menu item.) As long as entries are held in this temporary journal you may make changes to the entry or delete it.
Transfer Sales Journal Entries into Permanent Sales Journal - When entries have been made to the temporary journal and saved if you are satisfied with their correctness you may click this option to transfer the entries from the temporary journal to the permanent journal. NOTE: Once entries are transferred into the permanent journal they can not be changed. You should check and edit your entries, and make any changes you desire, before transferring them to the permanent journal. Entries are held permanently in the Sales Journal until you close the accounting year. After the entries are transferred to this permanent journal you may post the General Ledger accounts. All entries in the temporary journal will be transferred at the same time.
Post Sales Journal to Ledger - Select this option when you are ready to post a summary of the entries into each of the General Ledger accounts you have chosen for each entry. Entries can be posted to the General Ledger accounts only one time. The program will not allow double postings. Before posting to the General Ledger Accounts you will have the option to view the unposted entries on the screen by clicking on the View Unposted Entries sub menu item.
Print Journal - You can print a hard copy of the Sales Journal for either the Year-To-Date or for specific months. When printing the journal you may select the sorting order.
Search the Sales Journal - This option brings up a window in which you can enter a phrase, name, partial name, other words, accounts, or amounts to search for in the permanent journal. You can specify the search to be performed on any column of the journal.

2.2 Sales Journal Entries

Entries on this window are held in a Temporary Sales journal until you are ready to transfer them to the Permanent Sales journal. You may make changes to entries in this Journal at any time before they are transferred to the Permanent journal. After making entries on the top portion of the window click the OK button and the entry will be moved to the bottom part of the window. You may change or delete an entry by clicking on the line for that entry in the bottom window. After completing your entries click on Save Entries to save the Temporary journal. Each time you select the Sales journal from the main menu any transactions held in the Temporary journal are reloaded into the bottom window and are available for editing or deletion. Once the entries are transferred to the Permanent journal you may no longer change the entries.

**Figure 2.2:** GST Sales Journal Entry Window
$\includegraphics{8_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_saleentry.eps}$

Enter Sales for GST Calculations

This is the GST Sales Journal entry window. Enter all Sales on this screen which you want to include in GST Sales Tax Payable calculations. Entries are required for each box in the window When you click the OK button the entry data is moved to the list in the bottom of the window. Scroll up and down or across to see all columns and rows of the Sales Journal. Each entry creates one new line in the journal. There is no hard limit on the number of line items entered in this journal. However, we suggest you make no more than 20 to 25 entries before saving the entries and moving them to the permanent Sales Journal. (Rule of thumb = Don't make more entries than you are willing to re-enter if the computer crashes).

Sale Payment Method - Click the down arrow to see a selection of Payment Methods. This is the method you use to collect for the Sale. Choices for Payment Method are Cash Payment, or Other Sale Type. Selecting a Payment Method causes the Payment Receipt Account box to offer a selection of the correct General Ledger Account types for recording the sale. If you select Caash Sale you will be able to select from a choice of Cash tyype accounts. If you select Other Sale Type the Sale Payment Method box becomes active and you can type in whatever explanation you want. Selecting Other Sale Type also causes the Payment Receipt Account box to offer an expanded chart of accounts for recording the sale.
Payment Receipt Account - Double click the Payment Receipt Account box to see a selection of available General Ledger accounts that correspond to the Sale Payment Method. This is the account which will be debited with the full amount collected or due on the Sale. The default is a Cash Sale. For Cash Sales you must select a Cash account. For credit (charge) sales you must select an Accounts Receivable type account. For Other Sales Type, any type of account may be selected. (HINT: If you receive a payment by direct deposit or check deposited directly into the bank account, use the Other Payment Type as the Payment Method and select the proper bank account for the Payment Receipt Account. Cash Sale is intended to cover sales where actual cash is received.)
Entry Date - Today's date is the default when no entry has been made. Reset the date as needed. After each entry the date box is set to the last entry date to be ready for the next entry. It is very important to set the MONTH part of the date correctly since this determines the accounting period (month) in which the transaction is to be posted in the General Ledger. You can make changes to the date of an entry at any time before it is transferred from the temporary journal to the permanent journal. (Note: If you need to change the month of an entry after transferring it to the permanent journal, before it has been posted to the General Ledger, you may do so by accessing the Postgres table named, ``gstsalejnl'' directly and changing the column headed, ``fyprd''. If the entry has already been posted to the General Ledger the only way to change the period to which the entry has been posted is by an adjusting entry in the General Journal.)
Buyer Name - This is the name of the firm or person to whom you sold the item. The Buyer Name is stored in the journal for information purposes only and has no functional purpose in calculating GST.
Sale Description - This description is for your information purposes only and has no functional purpose in calculating GST.
Total Sale Amount - This is the total amount of the Sales including GST, if any. This is the amount you have or will receive from the Buyer for the item you sold.
GST Sale Type - Select the correct type of Sale according to GST rules. (Taxable Sale Including GST, Export Sale, Other GST Free Sale, or Input Taxed.). This selection trigers the GST account box and GST amount calculation box to be active if it is a taxable sale. If the sale is not taxable the GST boxes are hidden.
GST Account - For Taxable Sales you must select an entry in this box for the GST account number which you will use to record your Sales Tax Liability. This must be an GST Collected Liability type account and must be set up through the General Ledger Account Maintenance menu. This entry box will not be available if the Sales is of a type not including GST or not taxable.
GST Amount - The amount of the GST included in the Total Sale Amount, if any, will be automatically calculated and placed in this box. This is a liability for you. It is the amount of Sales GST liability you will carry in the GST Account and pay the government when you file. The General Ledger entry for each Sale will result in a debit to the Payment/Receivabl account and credits to the GST liability and Sales accounts. This entry box will not be available if the Sale is not taxable. You may override the GST Amount but the final total of the GST Amount and Net Sale Amount must equal the Total Sale Amount. If you change the Total Sale Amount the GST Amount and Net Sale Amount will be aoutomatically recalculated when you click the OK button. If you change either the GST Amount or the Net Sale Amount, and the Net Sale Amount is not equal to the Total Sale Amount the Net Sale Amount will be automatically recalculated and an error message will advise you of this change when you click the OK button.
Sale Account - Double click this box to select an account to record this Sale. This account must be either a Product Sale or Service Sale type account. This account will be posted with the net amount of the Sale after deducting GST included in the price, if any.
Net Sale Amount - This is the amount of the Sale after deducting GST included, if any. You may override this amount but the final total of the GST Amount and Net Sale Amount must equal the Total Sale Amount.

After you have completed entries click the Save Entries icon. This will save the entries in the temporary journal (shown in botton half of the window). If you attempt to exit without saving you will receive an error notice. You may then either save the batch of entries or exit without saving. If you exit without saving any new or changed entries made in the current session will not be saved. Entries from previous sessions will still exist in the temporary journal.

2.3 Transfer Sales Journal Entries into Permanent Sales Journal

After you have completed and saved the entries, and checked to see there are no errors or other changes, you must transfer the entries from the temporary journal into the permanent Sales Journal. Once transferred you can no longer access the entries using the journal entry window described above. (You can, however, make changes by going into the Postgres user interface and altering the entries. But, you must not change any amounts in the permanent journal if an entry has already been posted to the General Ledger. In this latter case use the General Journal to make adjusting entries for correcting the previous posting.)

Select the ``Transfer Sales Journal Entries into Permanent Sales Journal'' to initiate the transfer. No further action is required.

2.4 Post Sales Journal to Ledger

Posting to the General Ledger causes unposted entries in the GST Sales Journal to be summarized into totals for each General Ledger Account designated in your entries. The summarized total is then posted to the respective GL accounts. The Payment account will be debited and the GST accounts and Sales accounts will be credited with the totals of the summarized amounts. After posting the journal entries will be marked as posted to prevent posting a second time.

**Figure 2.3:** Sales Posting Procedure
$\includegraphics[scale=0.65]{2_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_postingopts.eps}$ $\includegraphics{9_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_postsalemonth.eps}$

Before posting to the General Ledger you should review the entries scheduled to be posted. Select View Unposted Entries to see the entries you are about to post. When you aresatisfied with the entries and are ready to complete posting of the entries select, Post Entries.

Before posting you must select the month for which you want the entries posted. (You may have unposted entries for more than one month in the Sales Journal and, for various reasons, may want to post only entries for a specific month.)

Click the drop down arrow to select the month. Click Execute to complete the posting.

2.5 View Journal On Screen and Print Journal

**Figure 2.4:** Journal Viewing and Printing Options
$\includegraphics[scale=0.65]{10_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_vusalesjnl.eps}$ $\includegraphics[scale=0.7]{11_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_salesortopts.eps}$

The Sales Journal may be viewed on the screen or printed on the system default printer.

Selecting either the View Journal or Print Journal options allow you to chose either a Year-To-Date Sales Journal or, a Monthly Sales Journal for a specific month. After you have selected the type of journal, and the month in the latter case, you may then select the order in which the journal is to be sorted.

Click the radio button by the sort order you want to use and then click the Submit button.

After selecting the sort order, if you selected a Monthly Sales Journal, you must select the month for which you want the report prepared.

**Figure 2.5:** Select Report Period
$\includegraphics{12_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_salerptmoselect.eps}$

Click the drop down arrow to select the month for the report. After selecting the report month click the Execute button. The report will be sent to the default system printer.

2.6 Search the Sales Journal

**Figure 2.6:** Searching the Sales Journal
$\includegraphics[scale=0.7]{13_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_salesearch1.eps}$

Setting up a search of the Sales Journal is a two step process.

Step 1 - Enter the word, characters, numbers, or pharase to search for. The search will locate all occurances of this text without regard to upper or lower case. After entering the numbers, words or phrase to search for click the drop down button in step 2 to see a list of possible data base fields to search. (In this example the search will locate any record containing the word, ``Jim'', or ``JIM'', or ``jim'', etc.)
Step 2 - Click the data field to search in the Sales data base. Searches are performed without regard to upper or loser case. The field searched will be the one you select here in step 2. If the result contians more than one record you may click to continue reviewing the results or cancel further searching.

Click teh Find button to start the search.

3. The BasicBooks GST Reports

You can prepare reports using either the Calculation Worksheet method or, since your books are kept on an actual transaction basis, if you otherwise meet the cash accounting requirement yau may use the ``derived from accounts method''.

3.1 GST Sale and Purchase Reports

From the General Ledger Main Menu select: Financial Reports

The last two items on the menu are the two GST reports available. These reports will include both the Sales and Purchase amounts for GST reporting.

**Figure 3.1:** GST Reports Menu
$\includegraphics[scale=0.65]{14_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_rptopts.eps}$

GST Summary Report - The GST Summary Report is a summary of each of the GST Purchase and Sale categories and a break out of the different GST Sales and Purchases amounts required for peparing the BAS. For the purchases portion Input Taxed, Private Purchases, and No GST Purchases over and under $1,000 are shown separately. The GST amount in this report is the actual GST recorded when you made the original purchase or sale entry in the Purchase or Sales Journal. (This corresponds to the ``Derived from Accounts Method'' of reporting.) Your entries for Input Taxed and Private purchases are included in the calculations without regard to GST rules regarding what is allowed for credits and what is not allowed. Sales are also included without regard to any special rules. You must make any appropriate adjustments to apportion amounts if any are required.
GST Worksheet - The GST Worksheet reports calculated amounts under the same headings used in the official GST Calculation Worksheet for preparing the BAS. The GST amounts are calculated by dividing Total Purchases and Total Sales by 11. Your entries for Input Taxed and Private purchases are included in the calculations without regard to GST rules regarding what is allowed for credits and what is not allowed. Sales are also included without regard to any special rules. You must make any appropriate adjustments to apportion amounts if any are required. You will have an opportunity to enter any adjustments before running the report.

3.2 Preparing the GST Worksheet and Summary Reports

The proceedure for both the Worksheet and Summary Reports is the same except for entering Sales and Purchases Adjustments (see below). No adjustments are entered before printing the GST Summary Report.

3.2.1 Entering Adjustments for the Worksheet Report

Bofore printing the GST Worksheet Report you may enter any Sales or Purchases adjustments needed for the report period. These adjustments will be included in the Worksheet Calculation. Adjustments are not entered when printing the GST Summary Report since this report is only a summary of transactions used for the Accounting Method of reporting. Data from the GST Summary Report must be transposed by you onto the BAS form and you can handle adjustments in that process.

**Figure 3.2:** GST Adjustment Entry
$\includegraphics{15_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_saleadj.eps}$ $\includegraphics{16_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_purchadj.eps}$

3.2.2 Selecting the Report Period

After entering any adjustments and before printing either style report you must select the period for which you are reporting GST Sales and Purchases.

**Figure 3.3:** Select the GST Reporting Period
$\includegraphics[scale=0.7]{18_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_gstrptprd.eps}$

Click the drop down arrow to select the beginning and ending months for the report. (Month selections are inclusive. e.g., in the display above the report will cover the months strarting with January and going through December.)

After selecting the report period click the Execute button. A pop up window will ask you to verify your period selection. Click OK to continue or NO to cancel.

Next, you may select to send the report to the System Default Printer.

**Figure 3.4:** Print Report
$\includegraphics{17_home_donpa_GSTBasicBooks_d_GSTManualSuplmnt_d_printrpt.eps}$

If you click the Print button he report will be sent to the default system printer. Click NO to cancel the print request. In either case, next you will have the option to save the report in the company report directory under the codata.d folder.