Deactivate your subscription
Getting Started - IPA Books+
Day to Day
Invoices - IPA Books+
Customer Adjustment Notes
Supplier Adjustment Notes
Chart of Accounts
Customer Statements - IPA Books+
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
Processing a Pay Run
Processing SuperStream Payments
Single Touch Payroll - IPA Books+
Processing EOFY - IPA Books+
Lodge Tax File Number (TFN) Declaration
Using IPA Books+ Timesheets with Payroll
FAQ - IPA Books+ STP
Bank Accounts - IPA Books+
IPA Books+ Transactions
Reconciliation - IPA Books+
Reconciling your accounts
Undoing a bank reconciliation
IPA Books+ Search
Import Chart of Accounts
IPA Books+ FAQ
Reconciling External Merchant Fees
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/Holiday 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
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 Detailed Pay Run Is Blank
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+?
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.
FAQ - Yodlee
Changing my Bank Login
Missing Latest Transactions
Connecting to Yodlee FastLink
Direct Bank Feeds
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.
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
The below help information is related to the integration between Reckon Ecommerce and IPA Books+.
Connecting to IPA Books+
You can connect Reckon Ecommerce to IPA Books+ and sync sales and tax information from ecommerce orders to your IPA Books+ accounts as journals.
- To connect to IPA Books+, you can either select ‘Enable’ via the dashboard setup task or go to Settings > IPA Books+.The book specific integration settings will now appear.
- Select which IPA Books+ book you would like to use. This will include a list of all books you have access to.
- Select the ledger account you would like ‘Sales’ information to post to, followed by which tax codes to use for sales with and without tax.If you want to create a new income/expense account in IPA Books+, simply create the account in IPA Books+ under Day to day > Chart of accounts.
Then come back to Reckon Ecommerce and select Refresh and you should now see the new account appear in the list as an option.
- Select the ledger account you would like ‘Freight’ information to post to, followed by which tax codes to use for freight income with and without tax.
- Select the ledger account you would like ‘Merchant Fees’ information to connect with, followed by which tax code to use for all merchant fee expenses. In most cases AU merchants should use GST, NZ and UK merchants should use the relevant tax free code. Please check with your provider.
- Click Save and you are done. All future orders will now be posted to IPA Books+ as a journal.
Explanation of journals
Rather than duplicate sales information in two systems, we post all Ecommerce orders as journals in IPA Books+. Journals show the underlying accounting ledger transactions for an order.
However fear not, as all you need to know is best achieved through your sales and tax reports in IPA Books+. You should not need to understand or even open a journal other than ensuring your Reckon Ecommerce orders have been created in IPA Books+.
Each ecommerce journal is broken into 4 parts:
Income from any products sold as part of an order. Sales information will be broken out per product of an order i.e. if an order contains a pair of shoes and a t-shirt, these will appear as separate journal line entries in your IPA Books+ journal.
Income from the customer for shipping of physical products. Digital products will not have freight income.
Expense of the processing fees for the order.
The clearing account is a ‘pseudo’ bank account created automatically for you and is used to reconcile your orders and transfers to your bank account. The total money expected from each order goes into your clearing account as a debit and actual transfers to your bank account go in as credit, allowing you to confirm you have received all funds owing.
Orders will be synced as soon as you connect your Reckon Ecommerce account to IPA Books+. You cannot sync orders that occurred prior to you making the connection.
A dispute occurs when one of your customers questions your charge with their bank or credit card company. Below is an explanation of how disputes are handled in your IPA Books+ journals. For general information on disputes, please see the Disputes FAQ
Once an order has been disputed, the funds in question will be held by our payment provider Stripe. At that point, a reversal journal will be created, effectively reversing the original sales journal so that your accounts balance. If the dispute is resolved in your favour, the funds will be sent back to you and a new sales journal will be created for the amount refunded to you.
You can offer a range of discounts to increase sales. These include item discounts, whole order discounts and free shipping (for physical items).
For whole order discounts, the discount amount will be proportionally deducted from each order line item in, ensuring your tax is accurately recorded for each journal entry.
For general information on discounts go to Adding discount codes and sharing discounted products.
If you need to issue a refund to a customer you can easily do so by following these steps: Issuing a refund.
Refunded orders will create a reversal journal for the amount of the refund. If the order is refunded in full, the reversal journal will be for the full amount of the original order. If a partial refund is issued, the amount refunded will be applied proportionally to the order line items.
Occasionally you might see a journal entry for ‘rounding’ with a few cents as the amount. This is required to balance very slight discrepancies with rounding of decimal places between your Reckon Ecommerce and IPA Books+ accounting platforms, where accepted yet differing accounting methods have been applied. It is critical that your IPA Books+ journal totals match your Reckon Ecommerce orders, and we use a rounding entry to achieve this.