Customer Portal
How to
Deadly Digits
Getting Started
Changing from a Single Sign In Login to a Username/Password one
Creating an Account
FAQ - Customer Portal
Updating your Details
Transferring Ownership
Adding Modules
Deactivate your subscription
Partners
Troubleshooting
Deadly Digits
How to
Getting Started - Deadly Digits
Day to Day
Recurring Transactions
Supplier Adjustment Notes
Estimates
Projects
Journals
Items
Chart of Accounts
Bills
Customer Adjustment Notes
Receive Money
Customer Statements - Deadly Digits
Expense Claims
Make Payments
Invoices - Deadly Digits
Timesheets
Contacts centre
Contacts
Payroll
NSW support package
JobKeeper Payment
JobKeeper reporting periods
JobKeeper Payment
The JobKeeper Extension Webinar by Clayton Oates (QA Business)
JobKeeper Payments FAQ
The JobKeeper Extension Webinar by Clayton Oates (QA Business)
Processing JobKeeper Payments in Deadly Digits
JobKeeper reporting periods
Adding JobKeeper Allowance pay items in Deadly Digits
JobKeeper Payments FAQ
JobMaker Credits
Employee invitation
Processing EOFY - Deadly Digits
FAQ - Deadly Digits STP
Processing Payments
Super Funds
Quick Guide
Using Deadly Digits Timesheets with Payroll
Lodge Tax File Number (TFN) Declaration
Processing a Pay Run
Payment Summaries
Processing SuperStream Payments
Pay Items
Employees
Single Touch Payroll - Deadly Digits
Banking
Fast Coding
Bank Accounts - Deadly Digits
Undoing a bank reconciliation
Reconciliation - Deadly Digits
Transaction Rules
Reconciling your accounts
Bank Transactions
Allocate Transactions
Bank Payments
Deadly Digits Transactions
Transfer Money
Suggested Matches
Reporting
Features
Import Chart of Accounts
Grossed-Up Transactions
Column Filters
Classifications
Deadly Digits Search
Document Storage
Book Settings
Integrations
Reconciling External Merchant Fees
Deadly Digits FAQ
Dashboard
Troubleshooting
Delete the bank transactions (QIF/CSV file) in bulk that was incorrectly imported.
Refund customer overpayment
Configuring and Understanding PayPal integration in Deadly Digits
Credit Card Account has no provision for a Credit Limit
Forcing an immediate update of your Yodlee bankfeed
How to update YTD balances on the Payment summary in Deadly Digits
Receiving a cash refund for an overpayment of a bill.
How do I enter ACN in Deadly Digits?
Super is not calculating
Error: Line item does not have a number, when entering TimeSheet entries on an Invoice
How to close a BankData Account in Deadly Digits
Manually Importing PayPal fee transactions.
Creating a new role for a user in Deadly Digits.
Looping issue when creating new Book.
Payable Type field in Deadly Digits
Setting up a BankData account on Deadly Digits
How to lock or unlock the book.
Supplier Overpayment
Unable to pay super guarantee for amounts below $450.00
Manually Importing PayPal transactions
Grey Screen When Trying to Print in Deadly Digits
Downloaded Bankdata transactions disappear from a Deadly Digits Book
Payment summary is out by Pays, which was done via YTD setup.
Latest Bankdata transactions not available in Deadly Digits Book.
Employees are unable to enter timesheets and/or Expense claims on Mobile app.
HTTP ERROR 504 when loading an Account Enquiry Report, and unable to load book. Blank screen
How to add or change or purchase the new modules? Activate /Deactivate Modules
How to enable Estimates or Quotes feature in my Book?
Recording RCTI in Deadly Digits or (buyer created tax invoice)
How do I enable Leave Loading to be included in Super calculations in Deadly Digits?
Unable to login to Deadly Digits Portal when Ad-blocker is installed.
Enter opening balances in Deadly Digits
“Error reading selected bank transactions” when clicking on Reconcile on the Banking Screen
Entering the FBT amount on the Payment Summary in Deadly Digits
Creating an ABA file for batch payments processing in bank, from Deadly Digits.
Creating customer statements
An error occurred submitting single touch payroll details to the API
Credit for GST tax paid on BAS does not match GST on Purchases on GST Summery Report
Access Denied or You do not have enough access rights ... attempting to view a Book on Mobile App
How to link Bankdata feeds and allocate transactions in Deadly Digits
How to process the Termination in Deadly Digits?
How to enter a Director’s Loan into a Deadly Digits Book
Recording SuperStream payments in Deadly Digits
“Invalid Company Information error” in GovConnect STP when submitting pays from Deadly Digits
How to update the billing information in Deadly Digits? How to change the credit card details
Can’t add a tax code to a transaction in the Payments and Receipts window of CashBook.
How to Setup and Calculate Super in Deadly Digits
Importing PayPal transactions and matching with my records from PayPal payment services.
Writing Off Bad-Debts in Deadly Digits:
"An error occurred while processing your request or the page you last visited does not exist anymore" when create/view a TPAR report
BankData signup & configuration for Deadly Digits
CashBook Online screen wobbles
Transaction rule does not pick up the transaction
The opening balance changes in a reconciliation when a transaction from previous month, is reconcile
STP Payrun Has No Figures Appearing
Cannot process a downloaded Bank Transaction - <> characters in the Description field.
How to unlock the bank account that has been locked after reconciliation.
Last financial year to date report does not show transactions to today
Removing an account from your Deadly Digits BankData Record
Submitting an STP Update Event or Full File Replacement in Deadly Digits
Understanding RESC in Deadly Digits
Invoice shows Due Date one day before Invoice Date
Error: The journal does not balance when marking pay run as Paid
No ability to unlink a bank ledger account from a bank feed
How to purchase the expired trial book?
The Cash/Bank status for this entry differs from what is was previously set to. This is not allowed
Why do I get an Error 522 when I attempt to add my bank account to my BankData record through Yodlee
Entering YTD Payroll balances in Deadly Digits, when migrating from another software.
Downloaded bank transaction does not allocate to bank ledger accounts
Create new user in Deadly Digits, Delete the user, share the book with accountants
Connecting your Book to your BankData feeds
How to switch the ownership of a bank feed
Text on Deadly Digits new design is not properly aligned
STP Screen has Doubled Up Employees & Gross Amounts in Deadly Digits
Invoices print with part of top and left side cut off
Processing SuperStream in Deadly Digits
Error - Tax code cant be entered for non-taxable items
Entering Gross Amounts (Tax inclusive) or Net Amounts (Tax exclusive) in your transactions.
How to Submit a Nil STP Submission to the ATO using Deadly Digits
Postings don’t balance when entering a Journal.
How to enable/process Taxable Payments Annual Reports (TPAR) in Deadly Digits.
Deadly Digits Invoice does not save.
How to stop reducing SG from Salary Sacrifice (new law effective from 1 Jan 2020) in Deadly Digits
Credit Card transactions no longer available in Deadly Digits after creating a new Yodlee feed
Cannot change Terms and Credit limits on the Deadly Digits App
Error – the value ‘/Date(14749879800000)/’ is not valid for StartDate
SSO (Google/Microsoft) accounts are unable to login from Mobile App.
Do not have a decimal point on the Deadly Digits App
Deleting a Deadly Digits BankData subscription
Duplicate Pay Runs Automatically Created in Deadly Digits
How to edit/delete the paid invoices in Deadly Digits?
Preparing Deadly Digits for Single Touch Payroll, (STP)
Processing GST payable and GST refunds to and from the ATO in Deadly Digits
Setting up and processing Payroll in Deadly Digits.
Editing and creating a new ABA file with an updated amount
‘Pay run error: the number credit is outside the valid range’ when finishing the termination payrun.
Processing Employment termination payments (ETP) in Deadly Digits:
Processing Time In Lieu in Deadly Digits
Bankdata
How to
Getting Started
Yodlee
Changing my Bank Login
Connecting to Yodlee FastLink
Missing Latest Transactions
FAQ - Yodlee
Feed Status
Direct Bank Feeds
UK
AU
Commonwealth Bank - Completing the Authorisation Form
Authorising BNZ Feeds
Setting up - Bendigo Credit Cards
Currently Support BankFeeds
BankData FAQ
Troubleshooting - Bankdata
Bankfeed missing transaction
Creating a direct feed to a Westpac bank account
Missing transactions in BankData downloads
Removing Duplicate transactions from a BankData import in Deadly Digits
You don’t have permission to request bank feeds for this account error when attempting to download B
Unexpected Error Adding Yodlee Feed for BankData
Handling Online Banking and BankData in the one company file
Forcing an immediate update of your Yodlee bankfeed
Bank Feed Management screen is missing some bank feed connections.
Latest Bankdata transactions not available in Deadly Digits Book.
Signing up for a Bankdata license on Reckon Accounts
Do not have an Operator ID to complete signup for an ANZ Credit Card account through Yodlee
Transactions for Yodlee accounts suddenly stop
Yodlee feeds do not automatically update
How to sign up an Australian ANZ Business Banking account to BankData
You dont have permission to request bank feeds .....for an ANZ Business One CC
Accessing Yodlee feeds with MFA for the first time
Bank Feeds available on Reckon Bank Data
How to Export transactions from your bank account
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
Why is my ATO status still saying ‘Pending’ and not ‘Success’, even days after submission?
STP upload Error, ‘instance.EmployeeData(*).Detail.Email is not any of (subschema 0),subschema 1),’
PayrollDetail requires property “TotalGross” and “TotalPAYG” error when uploading STP files.
Revoking the Multi-factor Authentication (MFA) for use on another device.
What is recovery PIN and how to access it in Reckon GovConnect STP portal
Error ‘Something went wrong’, when trying to open GovConnect
Common ATO STP Errors in Reckon GovConnect
Registering your software ID to ATO via ATO Access Manager.
How to revoke Multi-Factor Authentication using Recovery PIN in Reckon GovConnect STP portal
FAQS for GovConnect STP
Adding MFA via Chrome extension alternative to smartphone
Two Payment Summaries in MyGov account (one 'Tax ready' and one 'Not Tax Ready')
Final Event column showing as ‘No’ for my terminated employee(s) in the Reckon GovConnect Portal
My company’s legal name is long and doesn’t fit in the Legal name field. What can I do?
Error message 'Please contact the Tax Office', when submitting STP to ATO
- All Categories
- Deadly Digits
- How to
- Features
- Import Chart of Accounts
Import Chart of Accounts
How to Import a Chart of Accounts into Deadly Digits
1. Select the Chart of Accounts option from the settings menu
2. Select the Import chart of accounts option
3. Select your chart of accounts file to import. File types accepted are: csv and txt. You can either click Browse or drag drop your chart of accounts file into the box.
4. Configure the mapping options for your selected file
The column separator option allows you to tell Deadly Digits how the file handles columns. There are three choices available; Comma (default for CSV files), tab character and specific character (where you specify the character that has been used in the file).
The sub account separator option allows you to tell Deadly Digits how the file handles sub accounts. There are two choices available; colon character and the forward slash character.
The text qualifier option allows you to tell Deadly Digits how to handle any text qualifiers characters in the file. There are three choices available; single quote character, double quote character and none.
The import from row option allows you to tell Deadly Digits which is the starting row in the file that contains chart of account data. If the file contains header rows, then you can use this option to skip over those rows.
5. Map the columns that you wish to import using the drop lists available in the header row of the grid. There are eight choices available when mapping columns.
Ignore - Use this option for any column that you do not wish to import.
Name - Use this option for the column that contains the account name.
Type - Use this option for the column that contains the account type.
Code - Use this option for the column that contains the account code.
Export code - Use this option for the column that contains the account export code.
Description - Use this option for the column that contains the account description.
Status - Use this option for the column that contains the account status.
Tax code - Use this option for the column that contains the tax code.
Important things to know when mapping data
- The required columns to be mapped are; Name, Type and Status. The other columns (Code, Export code, Description and Tax code) are optional.
- Name and Code values must be unique within the file but also unique within the book.
- The Type, Status and Tax code columns only accept certain values. If an unknown value is detected, the unknown value will be shown in red and you can update it on the fly using the drop list available to that field.
- With exception to the sub account identifier character for the name column, the only special characters allowed are the hyphen character and the underscore character. This applies to the following columns; Name, Code, Export code and description.
- The following character limits apply;
- Name must be 300 characters of less,
- Code must be 10 characters or less,
- Export code must be 30 characters or less
- Tax code must be 10 characters or less
- If the selected file uses the forward slash character as the sub account identifier, then once you have configured the sub account identifier option, all instances of the forward slash character in the mapped Name column will be replaced with the colon character, as this is the expected character that is used by Deadly Digits.
- The Tax code column has inbuilt smart mapping. This smart mapping is available for Australian books only. Refer to the tax code mapping section further below for more information on how the smart mapping works.
There are two levels of validation when importing a file;
- The first level validation is the mapping validation. This occurs dynamically when completing the mapping process.
- The second level validation is the import validation. This occurs when all mapping validation has passed and you action the import.
- Mapping problems and import errors will be listed separately at the bottom of the import page. Clicking on issue message will show the applicable offending row so that you can correct the issue. If the issue covers multiple rows then the first instance of the issue will be shown.
- If a column contains a mapping error, the column value related to the mapping error will be shown in red coloured font.
- You can select or unselect rows to import using the tick box option which is available on the left side of each row. Only selected rows will be included when actioning the import.
- Deadly Digits is designed to work with it's own Account Receivable and Accounts Payable accounts. At this stage we do not allow any other Accounts Receivable or Accounts Payable accounts to be imported or used in Deadly Digits.
- Deadly Digits has a few system accounts which are restricted accounts. You will not be able to import sub accounts to these system accounts.
- In the event that an import partially succeeds (e.g. some rows import successfully and some do not), any rows that failed will be listed with the failure reason in the issues section at the bottom of the import page. Any rows that failed will remained selected in the grid and those rows that were successfully will now be unselected. You can then either correct those row issues and perform a subsequent import.
Tax code smart mapping
Tax code smart mapping applies to books with a region of AU only. Books with UK or NZ regions will not perform any smart mapping of tax codes.
Step 1 - Upload you chart of accounts file
Step 2 - Map/select the required columns: Name, Type and Status
Step 3 - Map/select the Tax code column
The tax code smart mapping will occur automatically once the Type column and Tax code column have been mapped.
How does the tax code smart mapping work?
If the data in the Tax type and Tax code columns match certain values, Deadly Digits will automatically update the Tax code column data using the smart mapping configuration listed in the tables below.
Reckon Accounts (RA) smart mapping
Example: If your Tax code column contains the code 'ADJ-P' then it will be updated to 'AJA'
RA code | RA code rate | R1 code | R1 code rate |
ADJ-P | 10% | AJA | 10% |
ADJ-S | 10% | AJS | 10% |
CAF | 0% | CAF | 0% |
CAG | 10% | CAG | 10% |
CAI | 0% | CAI | 0% |
CDC | 30.88% | CDC | 30.87448% |
CDG | 11.90% | CDG | 11.89768% |
CDS | 18.98% | CDS | 18.9768% |
EXP | 0% | EXP | 0% |
FRE | 0% | FRE | 0% |
GST | 10% | GST | 10% |
INP | 0% | INP | 0% |
NCF | 0% | NCF | 0% |
NCG | 10% | NCG | 10% |
NCI | 0% | NCI | 0% |
WC | 41.90% | WC | 41.90% |
WET | 29% | WET | 29% |
WGST | 12.90% | WGST | 12.90% |
Xero smart mapping
Example: If your Tax code column contains the code 'GST Free Expenses' then it will be updated to 'NCF'
Xero tax code | Xero tax code rate | R1 tax code | R1 tax code rate |
BAS Excluded | 0% | None | N/A |
GST Free Expenses | 0% | NCF | 0% |
GST Free Income | 0% | FRE | 0% |
GST on Expenses | 10% | NCG | 10% |
GST on Import | 0% | None | 0% |
GST on Income | 10% | GST | 10% |
QuickBooks Online (QBO) smart mapping
Example: If your Tax code column contains the code 'GST Free' then it will be updated to 'FRE'
QBO code | QBO code rate | R1 code | R1 code rate |
GST | 10% | GST | 10% |
GST free | 0% | FRE | 0% |
GST free exports | 0% | EXP | 0% |
GST on capital | 10% | CAG | 10% |
GST on non-capital | 10% | NCG | 10% |
GST-free capital | 0% | CAF | 0% |
GST-free non-capital | 0% | NCF | 0% |
Input tax | 0% | NCI if the Type column value matches: Expense or Other expense or Cost of goods sold or Cost of sales INP if the Type column value matches: Income or Other income None if the Type column value is anything else. | 0% |
MYOB smart mapping
Example: If your Tax code column contains the code 'GNR' and your Type column contains an account type from Group A then it will be updated to 'INP' or if the Type column contains an account type from Group B then it will be updated to 'NCI'
Account type A | Account type B |
Asset Equity Income Other Asset Other Income | Cost of Sales Expense Liability Other Liability Other Expense |
MYOB code | MYOB code rate | R1 code | R1 code rate |
FRE | 0% | FRE if account type A NCF is account type B | 0% |
GNR | 0% | INP if account type A NCI is account type B | 0% |
GST | 10% | GST if account type A NCG is account type B | 10% |
CAP | 10% | GST if account type A CAG is account type B | 10% |
GW | 41.90% | WC | 41.90% |
IMP | 5% | None (not available in R1) | N/A |
INP | 0% | INP if account type A NCI is account type B | 0% |
LCT | 25% | None (not available in R1) | N/A |
N-T | 0% | None (not available in R1) | N/A |
NTR | 0% | None (not available in R1) | N/A |
WEG | 12.9% | WGST | 12.9% |
WET | 29% | WET | 29% |
EXP | 0% | EXP | 0% |
ITS | 0% | INP if account type A NCI is account type B | 0% |
NDT | 0% | NTD | 0% |
PRI | 0% | None (not available in R1) | N/A |
QUE | 10% | None (not available in R1) | N/A |
CON | 10% | None (not available in R1) | N/A |