Not shown where? Can you post screen shots of what you mean?
Hi Lubos
Recently I have discovered that when importing the bank statement in QIF format - there is an error similar bank transactions appear three times!
Have you guys got any issues of this? I am not sure how to solve this problem - I could see one way sorting this problem by deleting one-by-one duplicated transactions.
Another option is start a new file and importing the bank statement, however having said that, as accounting data the previous quarters already exist, I donât want to delete whole file and redo again!
So if that is possible Manager create a folder keeping trace of importing bank statements in batch basis. If something happens to particular batch I could only delete that batch without affect other batched imported bank statement!
Hi Lubos
Please advise how did you guy handle inter-bank transfer. Other accounting software just do matching by itself - no further entries required. So far I create an contract account to net off each transfer to $nil!
Correct approach.
Can you show a screenshot of this occurring as this doesnât seem right.
With Manger, if you happen to import the same bank statement twice, it wont list (import) any transaction that already exists in that bank account.
If you are getting multiple entries then they could be in the file created by the bank. You could check that by opening the file from the bank in a spreadsheet programme before doing the Manager import.
It seems that the Linux version has no Import feature.
All operating system versions are the same. Read the Guide: Import bank statements | Manager.
1 Like
Yes Brucanna. Yes I knew that the Manager will prevent from importing repeated transactions as I was tested the importation of the bank statements in QIF by importing them twice and or mixing with different period with a sample file.All work well!
These incidents are happening to two companies so far - I thought that bank QIF transactions might be got an error. However having said that I have checked the QIF file by opening up in note format; there is no repeated transactions for the said period (sorry I did not take a screen as I shall!!).
I just re-create another company and re-import the same QIF and there is no repeated transactions!
As I see, there is not possible to allocate income/expense accounts during import, isnât? Would that be implemented some day in not distant future?
I have few files to import with at about 4000 bank transactions. Allocating accounts manually will take time, looking for a shortcut for that.
Exporting from Skrooge, which can produce CSV, QIF, JSON, Kmymoney, IIF, Sqlite, Sqlcipher or XML files for data exchange.
You can allocate income / expense accounts during imports in to ways:
- by clicking on âEditâ and manually entering the account
- by creating âBank Rulesâ which allows repetitive transactions to have the accounts allocated automatically
Thanks, I understand that, but I expect to have automated Account imported as well (Like Payee or other). On CSV I have separate column and it would be perfect it to turn into accounts.
Allocating 4000 transactions manually makes me think of worth of doing it.
By accounts I am guessing you mean Customers & Suppliers so their transactions can be posted directly. Not at this stage but there has been talk of expanding the bank rule to include such sub-accounts.
ok, thanks
Were you importing a .csv file, as this topic title suggests? If not, what file format were you importing?
thank you, it resolved . with this format
Date,Payee,Reference,Description,Amount
20-07-2017,InternetDebit,FT/000025671733/650014031332/BILL PAID 13052017,-54307
19-07-2017,Transfer Credit,CASH DEPOSIT BRANCH,20000
18-07-2017,Transfer Debit,IMPS/P2A/60258390077/MAHB/719910091987,-7000
16-07-2017,E-PaymentDebit,PG/JIDS5501916734/BILLDESK/LIGHT BILL,-640
16-07-2017,E-PaymentDebit,PG/JIDS5501899053/BILLDESK/TELEPHONE BILL,-389