Feature requested What feature would you like to see in QuickFile? A new field that can be used to store a unique reference for each transaction line within the banking records.
Typical use case
_How would this feature be used?_To allow user to sort transactions by this reference number. If some banking records get deleted by mistake the “missing” number would be easy to find.
How I would expect it to work
_To understand how this may work for users, provide some details of how you think it would work. This is completely optional, but it helps our team understand what you are looking for._The field would be for numeric data only. Ideally the user would provide the first number to be used just before the import is done and the import function could then add the consecutive numbers or the user could manually add the unique numbers to their import before this data is imported into Quickfile. If this field could be sortable in the banking transactions view it would allow the user an easy way to find banking discrepancies.
Thanks for the suggestion, we’ll leave it open for other users to add their vote.
How would you see this working if you missed a bank entry out after importing a list of transactions? How would the numbering be applied then? As an example, if the numbering is correct as of 31/08/2024, but then I accidentally import transactions for 05/09/2024, missing a few days.
Hi QFMathew
I advice all the companies I support to maintain a basic “cashbook” that is created in excel from data downloaded from their bank. This gives them a fixed record of their banking records which includes the unqiue number I would like to see shown in a seperate field on QF.
The data from the bank download includes the bank statement balance and I get users to use a calculation formula to check that their cashbook total calculation matches the total the bank has quoted.
The data that needs to be imported into Quick file is created by using the concatenate function to merge the range of cashbook detail fields the user wants to show in Quickfile into one field and this includes the unique number in brackets. The last Line item on the cashbook for each month also includes the bank statement balance in the description field so the user can check (by eye) on Quickfile - with no need to refer to their bank that the banking records on QF are accurate and if an errror does creep in will help to identify where it mistake started.
Using my method (importing data into QF from an excel spreadsheet not directly from bank statements allows the user to know immediately if they have messed up because the unique numbers would either be duplicated or have gaps.
For users who use QF but import directly from a bank statement they would only realise that they had done the import incorrectly when their bank balance on QF is found to not match their actual banking. The user would then have to find the line item where the banking records on QF and their bank account differ - select all the items added from that point (which should have a specific range of consquectutive unique numbers ) and delete them and then re-import the data correctly. These users could save the bank download data using a file name that includes the unique number range as a quick way to tie data on QF to their actual banking.
So I think it has a useful function for both types of users and would also prove very useful if you were comparing current data on QF to a backup copy.
I have just noticed the add a note function on the banking transactions. If this field could be imported into when doing a bank upload and be quickly viewable for all selected records on a banking view I would use this for the line item reference and notes. To make it really useful I I would also want the information to be included when QF data is exported to excel. Then I would have no need for the extra field - described above.
This seems like a rather convoluted way of just using the reconciling tools already built into Quickfile? I’ve reconciled accounts with missing transactions on Quickfile, takes minutes and I don’t need to delete anything, just add the missing one, no drama.
Hi Lurch, I have used the bank reconcile function in the past but stopped a while back because I couldn’t see that it did anything, except tell me that my figures balanced which I already know by comparing my final balance to my actual bank account balance. Is there something I have missed? If QF marked the items when they were reconciled with a reference for the period reconciled and that could be exported if errors creep in I could see that, that would be useful but I dont think it does that.
regards
Helensara