Account Keeping Plus – Administration, Bookkeeping, Compliance News & Tips MYOB Reckon Quickbooks Xero Software TrainingSmall Business

Making Business Books and Accounting Come Alive! MYOB Reckon Xero


Leave a comment

Reckon/Quickbooks – How to set up and how to report Taxable Payments Annual Report (TPAR) – and when due?

Reckon/Quickbooks – How to set up and how to report Taxable Payments Annual Report (TPAR) – and when due?

Reckon/Quickbooks – How to set up and how to report Taxable Payments Annual Report (TPAR) – and when due?

Businesses in the building and construction industries need to know how to report Taxable Payments Annual Report (TPAR) – so how do we set up the Reckon/Quickbooks file, how do we generate the report and when is the due date to report?

We start with the ATO requirements, then how to set up and create the report in Reckon/Quickbooks.

ATO Requirements

From the ATO website latest page 23 June 2016 –

Taxable payments reporting – building and construction industry

Businesses in the building and construction industry need to report the total payments they make to each contractor for building and construction services each year.

You need to report these payments to us on the Taxable payments annual report by 28 August each year.

To make it easier to complete the annual report, you may need to check the way you currently record your contractor payment information.

The information reported about payments made to building and construction contractors is used in our data matching program to detect contractors who have not either:

  • lodged tax returns
  • included all their income on tax returns that have been lodged.

Reckon/Quickbooks – The steps to set up and generate the report are –

1 . Enable the Taxable Payment Reporting option in the preference to be able to open the report

  1. Go to the Edit menu, choose Preferences.
  2. Choose the Tax item and go to the Company Preferences tab.
  3. In the Taxable Payment Report section, click to select the Enable the Taxable Payment Reporting option.
  4. Click OK.

2.  Enable a supplier (sub-contractor) to become reportable on the Taxable Payment report

  1. Go to the Suppliers menu and choose Supplier Centre.
  2. On the Suppliers tab, double click the supplier’s name to open the supplier’s profile.
  3. Click to select the “Include in Taxable Payments electronic report” option.
  4. Click OK.

3.  How do I create this report to have what I need to write on the ATO form?

  1. Go to the Suppliers menu, click Tax Activities, click Process Taxable Payments.
    The Process Taxable Payments annual report window opens.
  2. Click the Tax Year drop-down to select the tax year you are reporting on.
  3. If applicable, click the Withholding Liability Account drop-down to select the account you use to track withholding tax.
  4. Click the (tick) column to select the selected suppliers that you want to appear in the selected tax year’s report.
  5. Click the supplier to view the transactions for each supplier that are included in the report.
    The Supplier Taxable Payments Details – <supplier name> window opens.
  6. You can review each transaction and click to deselect if you don’t want it included.
  7. Click OK.
  8. Click Save to save the changes (if you have made them) in the Process Taxable Payments annual report window.
  9. Click Export to save the report to your disk. The Select Location for Tax Payment Report File window opens. Enter a file name for the report, we recommend using the date in the file name.
    The default location for the file is \\ProgramData\Intuit\ReckonAccounts 2013\<level> 2013\<Company Name>\Export Files\Tax Payment Reports. For Reckon Accounts Hosted users, the default location is “Q:\ “
  10. Click Save. You will receive a message that the file has been successfully written. If you have electronic key, you can upload the file to your ATO portal

Note: If you make any changes to the data whilst the Taxable Payments Annual Report Window is open, the report needs to be closed and reopened for it to refresh.

4.  How do you Amend the TPAR report if incorrect?

If you require to submit an amended report to the ATO, select the Generate Taxable Payments as ‘Amended’ option in the Process Taxable Payments annual report window.

Select the supplier that has been amended from the list and click Create Report.

Get a FREE 30 min answer to your query, and FREE ongoing email or phone support – No-one offers as much! Call and you also get FREE “Avoid these GST mistakes” – There’s 18 that the Tax Office see regularly – Get them right!

Email info@accountkeepingplus.com.au or call 0407 361 596 Australia


Leave a comment

Reckon/Quickbooks – Accounts Hosted and PC – How to set up and use ABA files to pay creditors – simplify!

Reckon/Quickbooks – Accounts Hosted and PC - How to change the email message for sales invoices

Reckon/Quickbooks – Accounts Hosted and PC – How to change the email message for sales invoices

(> means click)

Here is the procedure of how to set up and use ABA files to pay creditors (For Reckon Hosted and some recent Quickbooks versions) –

Before you can prepare an electronic payment file, you need to complete the following steps.

First – Set Up the a bank account in R for Online Banking

  1. Open the bank account you wish to enable for online banking
  • Go to the Lists menu, and click Chart of Accounts. The Chart of Accounts opens.
  • Select the bank account you want to enable, right-click and then select Edit Account. The account details open ready for you to edit.
  1. Click the Online Bank Details
  2. Click to select the Online Account Access check box. R makes a number of fields that relate to online banking active. Enter mandatory information about the online bank account set up with your bank.

Complete the following details:

  • Click the Financial Institution drop-down arrow and select the bank. This may take a few seconds to process.
  • Enter the code in the Branch Code field to identify the branch for the financial institution. This code is known in Australia as a BSB number.
  • Enter the account number in the Account Number
  • Click the Account Type drop-down arrow and select the type of account.
    You may choose cheque, savings, credit card, money market or line of credit.
  • Click to select Include Balance Record if you want to include a balance record for online banking files (ABA format) that you generate. This applies if you plan to pay employees or suppliers by generating online banking files (ABA format) in Reckon. Most banks require online banking files to include a balance record within the ABA file format. You should check with your financial institution first.
  • Enter an APCA number in the APCA number field for this account if it is different from the Default APCA number for your company. The APCA number entered in account details always overrides the default APCA number entered in company banking preferences for all online banking transactions using this account.
  1. Click Save & Close.

Second – Set up Suppliers and Employees for Online Banking

Updating Suppliers:

  1. Go to the Suppliers Centre then >Suppliers Tab >
  2. >Double Click a Supplier
  3. >Bank Details Tab >Enter Account Name (of Supplier), their Bank Account Number, Bank Name, Branch Code (BSB eg 083245, 6 digits) OK
  4. Repeat for all suppliers to be paid using ABA files, or that supply a bank account to pay (not Bpay suppliers usually)

Third  – Process Transactions and Create Online Banking File

Pay Bills

This involves processing transactions as normal, but at the Pay Bills window, Reckon should identify payments set up for banking online and have those ready to include when creating an online banking file. So ensure at the bottom the bank you set up for ABA id=s selected, and next to that the Payment Method is “Bank Online”. Finish transaction with Pay Selected Bills. Then Pay more Bills for the next suppliers to pay or Done to finish.

Create an online banking file:

  1. Go to the Online Banking Centre: > (top menu) Banking menu and click Online Banking Centre.
  2. Scroll to the section To Bank (at bottom).
  3. Choose the date you want the payment to be made, using the calendar from the Date to be Processed field or today’s date as defaults.
  4. Enter a payment description eg Creditors or Bills or Pays. If no payment description is entered, a description of “payment” will display in the ABA file by default.
  5. Tick payees from the list. Each payee must have a bank account defined for them under their employee or supplier record. This includes details for Bank Account Name, Number and Branch Code. In addition, employees must have an employee number.
  6. Click Preview ABA File if you wish to review the ABA file before creating it.
  7. Click Create ABA File. Reckon displays the standard Windows Save As dialog box with *.ABA entered in the file name at the end.
  8. Enter a name for the online banking file (leaving the .ABA) and choose a location to save it, such as desktop. Reckon provides a default folder within the installation directory called Export Files/ ABA Files. You may choose to save the ABA file in this directory, or in any other directory of your choice.
  9. Click Save.
  10. Your ABA file is now ready for upload to the relevant financial institution.
  11. Follow their online instructions to upload a payment file.

Get a FREE 30 min answer to your query, and FREE ongoing email or phone support – No-one offers as much! Call and you also get FREE “Avoid these GST mistakes” – There’s 18 that the Tax Office see regularly – Get them right!

Email info@accountkeepingplus.com.au or call 0407 361 596 Australia


Leave a comment

Reckon ONE – Support User guides and How-to Videos

Reckon ONE – Support User guides and How-to Videos

Reckon ONE – Support User guides and How-to Videos

Have you started with Reckon One? It is the Reckon online accounting software where you pay for the modules you need – starting at $5 month, you can enter data and reconcile the bank, report on GST for BAS, online backup and 24/7 support. Then invoicing $3, bank feeds of transactions into the software $3, and payroll $3 – each is billed monthly for each module – eg all these listed come to 5+3+3+3. = $14 monthly.

Want some videos and manuals?

Training Reckon ONE http://go.reckon.com/training-one/ starts at live webinars to attend/book

Next tab is Videos page – http://go.reckon.com/newreckonone-videos/

Next tab is Recorded Webinars – http://go.reckon.com/reckon-one-recorded-webinars/(getting Started, Core Modules, Invoices, Projects (Jobs) and Bank Data Module)

YouTube videos – payroll

Payroll set up https://youtu.be/3t_yQ1F5wew

Process Pay Run https://youtu.be/T4_V1PjT5BY

User Support & Guide download from –http://home.reckon.com.au/support/Home/ReckonSupport/InstallationUpgradeGuides.aspx

Community Reckon One – https://community.reckon.com/reckon/categories/reckonltd_reckon_one  where you can search your topics at the top search box

Knowledge Base (KB) – FAQs and Search links – http://kb.reckon.com.au/index.asp

Also don’t hesitate to contact us if you have any questions on 1300 756 663 or onlinesales@reckon.com.au.

Or call us! – 0407 361 596 Paul for free help up to 30 min!

Need help? Not sure? Call for FREE 30min advice / strategy session today!

Call and you also get FREE “Avoid these GST mistakes” – There’s 18 that the Tax Office see regularly – Get them right!

Email info@accountkeepingplus.com.au or call 0407 361 596 Australia