IPA Books+
How to
Getting Started - IPA Books+
Day to Day
Recurring Transactions
Estimates
Invoices - IPA Books+
Customer Adjustment Notes
Receive Money
Bills
Supplier Adjustment Notes
Make Payments
Chart of Accounts
Projects
Items
Timesheets
Expense Claims
Journals
Customer Statements - IPA Books+
Contacts centre
Contacts
Payroll
NSW support package
JobKeeper Payment
JobKeeper Payment
JobKeeper reporting periods
Processing JobKeeper Payments in IPA Books+
Adding JobKeeper Allowance pay items in IPA Books+
The JobKeeper Extension Webinar by Clayton Oates (QA Business)
JobKeeper Payments FAQ
JobKeeper Payments FAQ
JobKeeper reporting periods
The JobKeeper Extension Webinar by Clayton Oates (QA Business)
JobMaker Credits
Quick Guide
Pay Items
Employees
Employee invitation
Processing a Pay Run
Processing SuperStream Payments
Super Funds
Single Touch Payroll - IPA Books+
Processing EOFY - IPA Books+
Payment Summaries
Processing Payments
Lodge Tax File Number (TFN) Declaration
Using IPA Books+ Timesheets with Payroll
FAQ - IPA Books+ STP
Banking
Bank Accounts - IPA Books+
Bank Transactions
Suggested Matches
Allocate Transactions
IPA Books+ Transactions
Fast Coding
Reconciliation - IPA Books+
Reconciling your accounts
Undoing a bank reconciliation
Transfer Money
Transaction Rules
Bank Payments
Reporting
Book Settings
Features
Document Storage
IPA Books+ Search
Grossed-Up Transactions
Classifications
Column Filters
Import Chart of Accounts
Integrations
IFA Books+ (UK)
Making Tax Digital (MTD) for VAT
Making Tax Digital (MTD) for VAT introduction
General VAT settings
VAT details
Authorising MTD for VAT
VAT rates
Populating your MTD for VAT return
VAT reports
Preparing and submitting a VAT return
Re-authorising MTD for VAT.
Postponed VAT Accounting
XML VAT return submissions
UK Domestic Reverse Charge scheme
Temporary reduced 12.5% VAT rate
Dashboard
IPA Books+ FAQ
Reconciling External Merchant Fees
Troubleshooting
IFA Books+ (UK) troubleshooting
Entering YTD Payroll balances in IPA Books+, when migrating from another software.
Payable Type field in IPA Books+
Unable to login to IPA Books+ Portal when Ad-blocker is installed.
Preparing IPA Books+ for Single Touch Payroll, (STP)
How to enter a Director’s Loan into a IPA Books+ Book
Duplicate Pay Runs Automatically Created in IPA Books+
How to Submit a Nil STP Submission to the ATO using IPA Books+
Access Denied or You do not have enough access rights ... attempting to view a Book on Mobile App
Submitting an STP Update Event or Full File Replacement in IPA Books+
How to switch the ownership of a bank feed
Why do I get an Error 522 when I attempt to add my bank account to my BankData record through Yodlee
‘Pay run error: the number credit is outside the valid range’ when finishing the termination payrun.
Payment summary is out by Pays, which was done via YTD setup.
Can’t add a tax code to a transaction in the Payments and Receipts window of CashBook.
Setting up and processing Payroll in IPA Books+.
How do I enable Leave Loading to be included in Super calculations in IPA Books+?
“Invalid Company Information error” in GovConnect STP when submitting pays from IPA Books+
Unable to pay super guarantee for amounts below $450.00
“Error reading selected bank transactions” when clicking on Reconcile on the Banking Screen
Text on IPA Books+ new design is not properly aligned
Error – the value ‘/Date(14749879800000)/’ is not valid for StartDate
Recording RCTI in IPA Books+ or (buyer created tax invoice)
Processing Time In Lieu in IPA Books+
Connecting your Book to your BankData feeds
"An error occurred while processing your request or the page you last visited does not exist anymore" when create/view a TPAR report
How to close a BankData Account in IPA Books+
Importing PayPal transactions and matching with my records from PayPal payment services.
Credit for GST tax paid on BAS does not match GST on Purchases on GST Summery Report
Employees are unable to enter timesheets and/or Expense claims on Mobile app.
Downloaded Bankdata transactions disappear from a IPA Books+ Book
Writing Off Bad-Debts in IPA Books+:
How to link Bankdata feeds and allocate transactions in IPA Books+
Creating a new role for a user in IPA Books+.
Postings don’t balance when entering a Journal.
Error - Tax code cant be entered for non-taxable items
Deleting a IPA Books+ BankData subscription
How to Setup and Calculate Super in IPA Books+
HTTP ERROR 504 when loading an Account Enquiry Report, and unable to load book. Blank screen
Super is not calculating
Setting up a BankData account on IPA Books+
Error: Line item does not have a number, when entering TimeSheet entries on an Invoice
The Cash/Bank status for this entry differs from what is was previously set to. This is not allowed
Downloaded bank transaction does not allocate to bank ledger accounts
Entering Gross Amounts (Tax inclusive) or Net Amounts (Tax exclusive) in your transactions.
How to add or change or purchase the new modules? Activate /Deactivate Modules
Credit Card transactions no longer available in IPA Books+ after creating a new Yodlee feed
Manually Importing PayPal fee transactions.
How to lock or unlock the book.
How to enable Estimates or Quotes feature in my Book?
Recording SuperStream payments in IPA Books+
STP Payrun Has No Figures Appearing
How to update YTD balances on the Payment summary in IPA Books+
Invoice shows Due Date one day before Invoice Date
Editing and creating a new ABA file with an updated amount
The opening balance changes in a reconciliation when a transaction from previous month, is reconcile
Removing an account from your IPA Books+ BankData Record
Transaction rule does not pick up the transaction
Configuring and Understanding PayPal integration in IPA Books+
Creating customer statements
Entering the FBT amount on the Payment Summary in IPA Books+
Understanding RESC in IPA Books+
BankData signup & configuration for IPA Books+
Do not have a decimal point on the IPA Books+ App
CashBook Online screen wobbles
Processing Employment termination payments (ETP) in IPA Books+:
Refund customer overpayment
Delete the bank transactions (QIF/CSV file) in bulk that was incorrectly imported.
SSO (Google/Microsoft) accounts are unable to login from Mobile App.
Processing SuperStream in IPA Books+
An error occurred submitting single touch payroll details to the API
Credit Card Account has no provision for a Credit Limit
Creating an ABA file for batch payments processing in bank, from IPA Books+.
Manually Importing PayPal transactions
How to update the billing information in IPA Books+? How to change the credit card details
How to enable/process Taxable Payments Annual Reports (TPAR) in IPA Books+.
No ability to unlink a bank ledger account from a bank feed
How to purchase the expired trial book?
How to edit/delete the paid invoices in IPA Books+?
Supplier Overpayment
How do I enter ACN in IPA Books+?
Enter opening balances in IPA Books+
Processing GST payable and GST refunds to and from the ATO in IPA Books+
Latest Bankdata transactions not available in IPA Books+ Book.
Cannot process a downloaded Bank Transaction - <> characters in the Description field.
Create new user in IPA Books+, Delete the user, share the book with accountants
Invoices print with part of top and left side cut off
Forcing an immediate update of your Yodlee bankfeed
Grey Screen When Trying to Print in IPA Books+
Receiving a cash refund for an overpayment of a bill.
How to unlock the bank account that has been locked after reconciliation.
Cannot change Terms and Credit limits on the IPA Books+ App
IPA Books+ Invoice does not save.
Last financial year to date report does not show transactions to today
How to process the Termination in IPA Books+?
How to stop reducing SG from Salary Sacrifice (new law effective from 1 Jan 2020) in IPA Books+
STP Screen has Doubled Up Employees & Gross Amounts in IPA Books+
Looping issue when creating new Book.
Customer Portal
How to
IPA Books+
Getting Started
Creating an Account
Updating your Details
FAQ - Customer Portal
Changing from a Single Sign In Login to a Username/Password one
Transferring Ownership
Adding Modules
Deactivate your subscription
Partners
Troubleshooting
Bankdata
How to
Getting Started
Yodlee
Feed Status
FAQ - Yodlee
Changing my Bank Login
Missing Latest Transactions
Connecting to Yodlee FastLink
Direct Bank Feeds
BankData FAQ
Troubleshooting - Bankdata
Bank Feed Management screen is missing some bank feed connections.
Missing transactions in BankData downloads
Removing Duplicate transactions from a BankData import in IPA Books+
Signing up for a Bankdata license on Reckon Accounts
Latest Bankdata transactions not available in IPA Books+ Book.
Bank Feeds available on Reckon Bank Data
Forcing an immediate update of your Yodlee bankfeed
Bankfeed missing transaction
Accessing Yodlee feeds with MFA for the first time
Creating a direct feed to a Westpac bank account
Yodlee feeds do not automatically update
Do not have an Operator ID to complete signup for an ANZ Credit Card account through Yodlee
You dont have permission to request bank feeds .....for an ANZ Business One CC
Handling Online Banking and BankData in the one company file
How to Export transactions from your bank account
How to sign up an Australian ANZ Business Banking account to BankData
Unexpected Error Adding Yodlee Feed for BankData
Transactions for Yodlee accounts suddenly stop
You don’t have permission to request bank feeds for this account error when attempting to download B
Don’t have permission to download Bankdata on my Credit Card Number.
Bankdata: Re-verify Your Login Credentials / "You need to use your netlock device" for Commbiz
Reckon GovConnect
How to
Troubleshooting
My company’s legal name is long and doesn’t fit in the Legal name field. What can I do?
Error ‘Something went wrong’, when trying to open GovConnect
Registering your software ID to ATO via ATO Access Manager.
Why is my ATO status still saying ‘Pending’ and not ‘Success’, even days after submission?
Revoking the Multi-factor Authentication (MFA) for use on another device.
PayrollDetail requires property “TotalGross” and “TotalPAYG” error when uploading STP files.
Two Payment Summaries in MyGov account (one 'Tax ready' and one 'Not Tax Ready')
What is recovery PIN and how to access it in Reckon GovConnect STP portal
STP upload Error, ‘instance.EmployeeData(*).Detail.Email is not any of (subschema 0),subschema 1),’
Common ATO STP Errors in Reckon GovConnect
How to revoke Multi-Factor Authentication using Recovery PIN in Reckon GovConnect STP portal
Error message 'Please contact the Tax Office', when submitting STP to ATO
Adding MFA via Chrome extension alternative to smartphone
Final Event column showing as ‘No’ for my terminated employee(s) in the Reckon GovConnect Portal
FAQS for GovConnect STP
- All Products
- Bankdata
- How to
- BankData FAQ
BankData FAQ
What is BankData?
BankData is a Reckon facility to connect your Reckon accounting software (Accounts Business, Reckon Accounts Hosted and IPA Books+) to your nominated bank accounts to provide a seamless import of your bank transactions.
What is a Direct Bank Feed?
A direct Bank Feed is a secure direct connection between your Bank and Reckon to send transactions from your bank account to Reckon accounting product.
Can I access all my bank accounts through direct bank feeds?
No. Which accounts are not accessible may vary from bank to bank, so you should consult your Bank Relationship Manager for a full list of which type of accounts can and cannot be accessed.
Generally, transactional accounts without special conditions are accessible by direct bank feeds.
Credit Card Accounts are not accessible.
Any account that does not have a BSB (Bank State Branch) number is not accessible – for instance Home Loan Accounts
Special Condition accounts – like Loan Accounts, High Interest Savings Accounts – generally are not accessible.
What information must I supply to Reckon to establish a direct bank feed.
We need sufficient information to match the bank’s account to a BankData record. You must provide:
Add a new Bank Feed Screen
Country | Australia or New Zealand |
Account Type | Bank or Credit Card |
Financial Institutions (direct links available) | Bank selection will show only those banks with direct bank feeds: AUS: ANZ CBA NAB WBC SGB BSA BoM BoQ Ben Rural Heritage NZ: ANZ WBC ASB KiwiBank NBS TSB For other banks select: My financial Institution is not in the list (will open a Yodlee selection box) |
Financial Institutions supported by Yodlee Inc | Most banks are here. Some banks have incompatible systems with both direct feeds and Yodlee and therefore cannot be accessed (Bendigo Bank). : Some banks may block Yodlee from access. |
Credit Cards | Only accessible via Yodlee You will have access to all Credit Cards on your account An 8-digit Yodlee ID will be issued via email the next day. You will not be asked for any account numbers. |
Enter bank account details
Account name | as it appears on your Bank Statement and cheques |
BSB: | 6-digit number. NZ use first 6 digits of your 16-digit number
|
Account Number | If the first digit is zero, omit it and the system will account for it when activated by the bank. NZ – start at the 7th digit of your 16-digit account number. |
A “3rd party access” authorisation form for your bank to authorise the bank to send a copy of transactions on your nominated bank accounts to Reckon via the direct bank feed.
Yodlee will request your Online banking sign on credentials.
Depending on the institution you will be required to enter two or three pieces of information
You will not be asked for any account numbers. Yodlee will make available all credit card accounts on this sign on; or in the case of bank accounts, to all bank accounts on this sign on.
Customer Number | Customer number of Internet access number |
Security Number
| May or may not be asked by your institution. May be called an Access code or PIN. |
Password | Password |
You do not require to sign any authorization forms, however be aware .
Who can sign the “3rd party access” form?
All applications to the bank must be signed in accordance with existing authorities held by the bank.
Accountants, Bookkeepers and Consultants should take special care that forms are signed by their clients and not themselves.
In some cases the name on the bank account may be different to the name of the Business and the name on the Reckon Customer database.
How long does it take from sign-up to being activated?
Under normal conditions you should allow 8 days. The length of actual time will depend on the speed at which you deliver signed forms to Reckon and whether there are any irregularities with the “3rd party access” authority form. Where the bank is not satisfied with the form they may refer the form to the local branch for clarification and contact with the account holder.
How many bank accounts can I add to my BankData record?
You can have as many accounts as you like, from any number of financial institutions.
Can I add more accounts to the “3rd party access” form?
The “3rd party access” form is populated for the details you entered in your BankData signup.
Yes, you can add more accounts to the form you receive, but then you must add these accounts to your BankData record.
How do I add more accounts on to my BankData record?
On the Bank Feed management screen, click on Add Feed and add the details. You will need to submit a “3rd party access” form to Reckon at Bankdata@reckon.com for this account signed in accordance with the authority held by the bank on this account.
How do I remove an account from my BankData record?
On the Bank Feed Management screen, at the end of the entry for that account, click on the Trash Can.
What setup do I need to do in my Accounts Business and Hosted to access BankData?
You need to provide details in two areas:
- Edit > Preferences > Banking > Company Preferences
- Tick the box Enable Bankdata
- Enter your UserID in BankData User Id: box;
- Enter your BankData Password
- Lists > Chart of Accounts > right-click YourBankAccount > Edit > Online Bank Details tab:
- Enter details for:
- Financial Institution
- Branch Code (BSB number) - Note: numbers only - no dashes
- Account Number – bank account or credit card
- Account type
- Tick: Include Balance Record
- Enter APCA number: default no. is 111111
- Yodlee ID is entered only for Yodlee access
- Enter details for:
What setup do I need to do in my IPA Books+ to access BankData?
The owner of Bankdata needs to link the bank feed to the bank account register:
- Transactions > Banking
- Click on Connect to your bank
- Wait while information about your BankData feed populates
- On the bank account line, click on Link this to a bank account
- Select the relevant bank account and click Save.
How do I import Bankdata into my Accounts Business and Hosted?
- Banking > Online Banking Centre
- Click on Import BankData button
- Select Bank Account and date range
- Click OK on the Transaction Summary screen
- Add or match transactions into your company file.
How do I import Bankdata into my IPA Books+ Book?
- Transactions > Banking
- Click on the Reconcile button for your account
- Use either Find Match or select from More Options
- For regular transactions you can create a Rule for automatic entry
From what date can I import transactions?
Bank transactions are available from the day your Bank activates your bank account for direct Bank feeds – that is after they have received and accepted your “3rd party access” authority.
Subsequent BankData imports will give you transactions entered into your bank account since the last import was done.
Do I have to import all transactions into Accounts Business and Hosted in one session?
No. You can define a smaller date range to import. Only when the transactions are entered into your bank register will the transaction be fully processed and no longer be available to enter again.
Do I have to import all transactions into IPA Books+ in one session?
No you do not. Transactions will remain in your Transactions from Bank List until they are entered into your book. However, if you leave the BankData screen before processing all transactions, when you return the screen may be blank. In this case:
- Calculate the number of days from the last processed transaction.
- Administration > Settings > General settings (section) > Book settings > BankData - retrieve last "n" days.
- Enter the number of days from today to the date of the last reconciled transaction.
- Go to Banking > Transactions > your bank account
- Your Bankdata transactions from the day after the last reconciled transaction will appear.
- Transactions from before the date of the last reconciled transaction will need to be entered manually and then reconciled manually. If you still have a large number of transactions then you can export those transactions from your bank website into a QIF file and import it into your IPA Books+ book.
What Account Types arent available via BankData?
Non-standard accounts such as Home Loans, Term Deposits and any Accounts with restrictions aren't available via BankData. There is an initiative in Australia and New Zealand called Open Banking due to start in 2020 which will enable banking customers to get Feeds from any account types. We will provide more information around Open Banking closer to the time.
How do I cancel my BankData plan?
In Accounts Business
- Log on to bankdata.reckon.com
- On each bank account line, click on the Trash Can
- When all entries deleted, at the top of the table click on cancel plan.
In IPA Books+
- Control Panel > Bank Feed Management
- On each bank account line, click on the Trash Can
- At the top of the table click on cancel plan
- On your Book icon, click Module and for BankData select None option and proceed to the Checkout.