I am having problems with Manual Bank Feeds in New Reckon One. After I allocate transactions and click ok, they appear on both the allocated and unallocated tabs. This makes it confusing. My logic tells me somewhere that once allocated, the transaction should completely disappear from the "unallocated tab". This means that when I go to reconcile, I have found that I have sometimes allocated transactions twice. I then have to go and delete the transactions. I am trying to work around this problem. This does not happen on the older version. Is any one else having that issue, and is there a way to fix it. It does not appear to happen for transactions with a Linked bank feed.
I have spoken to Reckon about the issue raised in the first post on this thread & have an update to share with you.
The issue where the 'Unallocated' tab shows previously actioned transactions for manual uploads.
So for example:
1. Day To Day (menu) > Banking > Select/view the relevant bank account
2. Import a bank statement (QIF or CSV) via the manual upload option
3. The 'Unallocated' tab in the banking screen shows the transactions you have just imported
4. Action one or more of these transactions
Result: Actioned transactions are moved out of the 'Unallocated' tab, into the 'Allocated' tab & show a default status of reconciled.
The issue where actioned transactions were reappearing in the 'Unallocated' tab is now fixed for any transactions that you now action moving forward.
However, you cannot match existing transactions so you have to 'ignore' the transaction.
- if your using invoices & payments.
- if your using bills & payments.
- if your using a 'cash on hand' bank account then transfer it to a bank account once banked.
- if your paying multiple payee (via online banking) which result in a lump sum on your account.
(this type of bank transaction has to be ignored in reckon one so you can allocate the each payee)
- if your doing any transactions in a bank account prior to the manual upload.
All ignored transaction reappear in unallocated. The upload will never be marked as completed.
Just an update on this thread. With today's Reckon One update, you can now match unallocated transactions against allocated transactions & also delete transactions directly from the allocated tab (reconciliation screen).
Here's a quick summary...
The unallocated tab for a bank account shows imported transactions that have yet to be actioned/allocated. These transactions may have been imported via a bankfeed, QIF file or CSV file.
Previously Reckon One auto matched unallocated transactions against transaction rules. Now Reckon One also auto matches unallocated transactions against allocated transactions in the bank account.
Note: If an unallocated transaction matches both
an allocated transaction & also a transaction rule, the allocated transaction
match takes priority.
When a match is found, the unallocated transaction shows a status Existing matched. Clicking OK removes the unallocated transaction from the unallocated tab. If the allocated (matched) transaction was previously unreconciled, it’s now marked as reconciled.
If you hover the mouse cursor over the status Existing matched, a tool tip will appear giving you more information about the match.
Here is an example of a tool tip relating to a transfer match
Here is an example of a tool tip relating to a receipt
Here is an example of a tool tip relating to a payment
matching process uses the date & amount information of the unallocated
transactions to check for matches against the allocated transactions (receipts,
payments & transfers) in the bank account.
Reckon One first checks for a match on the same date. If no match is found, Reckon One then checks 1 day either side of the transaction date.
The unallocated tab contains the following transaction
Amount: $50.00 (money in)
1. Reckon One checks for a match on the 01/07/2015 for $50.00 (money in)
2. If no matches are found, Reckon One checks for a match on the 30/06/2015 for $50.00 (money in)
3. If no matches are found, Reckon One checks for a match on the 02/07/2015 for $50.00 (money in)
In the scenario where a match is found & the allocated (matched) transaction is dated either the day before or the day after the unallocated transaction, if the user accepts the match, the allocated transaction retains its date.
In the scenario where an unallocated transaction has multiple matches for a single date, the first match will be used. More advanced matching & searching functionality will be added to the application at a later date that will allow you to manually search & choose a specific match.
In the scenario where an unallocated transaction has a match but the match isn’t relevant. You can action the transaction manually using the action option.
Regarding the deletion of transactions from within the allocated tab (reconciliation screen).
When you hover the mouse over a transaction row/line, the delete option "X" is available on the right section of the applicable row/line.
Just an update on this thread. Today's Reckon One update (24th March 2016) includes an enhancement to the banking area. You can now delete imported bank transactions which haven’t yet been allocated or matched.
To delete an imported transaction, view the New tab (previously named Unallocated) for the applicable bank account, hover the mouse cursor over the transaction that you want to delete & click the X icon located in the right section of the transaction.