I have done my first Bank Import and seen how the process works. I did backup my database first! I have worked out that I need to use Accounts Receivable and Accounts Payable. I think that this is because I am using Sales Invoices and Purchase Invoices. If you are doing Cash (no invoices) - you nee…

Yes Bank imports are just a different way of typing in the data. In the past you have manually entered Receipts & payments, selecting invoices or other Manager accounts directly for cash sales. The individual transactions in bank imports need to be identical to the manual entries you created in th…

The one thing that I have noticed is that it doesn’t allocate to the last invoice. I have a feeling I was asking about that somewhere. So bulk import works and I can see which Invoices I have forgotten to create as it shows account payable for missing purchase invoices. So yes the import should sav…

I have just seen another issue. It does not add the Contacts automatically. Maybe the bank rules should have a field for Contacts.

[image] dalacor: pity about not linking the payment to last unpaid invoice. Your comments on this subject a little bit puzzling. Are you saying, for example, that an imported receipt allocated to Accounts receivable > Customer X will not be applied to the unpaid invoice of Customer X with the…

I am talking about the Payee Field in Receipts and Payments. This is blank when importing the bank statement. In the past I used to fill in the field with Client or Supplier name. Then it shows in the contact column in Receipts and Payments Yes it pays the oldest invoice first. What I mean is that …

It would not add invoice numbers to payments or receipts if done manually, either. It is payment or receipt information that is added to invoices, in the mini-statement. Remember, you can also edit the imported transactions either before or after creating them.

Yes I know it has to be added manually. What I am saying is that it would be useful to automate it based on paying off the last invoice if this were programatically possible.

[image] Tut: Remember, you can also edit the imported transactions either before or after creating them Agree. Achieving a balance between Fully automatic / complete bank rules Fully manual bank import entry Bank rules requiring partial editing each receipt / payment Is the key

Yes essentially that is what I am looking for. Adding the Contact to the Bank Rule makes sense because it’s always going to be the same contact for that description. As for the Invoice Number info, I suspect that it would make sense to program payments to dynamically allocate the last paid invoice…

[image] dalacor: Adding the Contact to the Bank Rule makes sense because it’s always going to be the same contact for that description. Agree but it is probably going to be more efficient to add that functionality after linking to the customer or supplier database is added [image…

Import bank Statement Question

Uncategorized

Patch January 17, 2020, 1:28pm 11

Agree but it is probably going to be more efficient to add that functionality after linking to the customer or supplier database is added

Topic		Replies	Views
Matching imported bank transactions with invoices Uncategorized	11	2961	November 20, 2017
Bank statement import ignores Payee column Uncategorized	27	1335	February 21, 2021
Bank statements, sales invoices and receiving money Uncategorized	15	1561	March 24, 2017
Import bank transaction OR make an invoice Uncategorized	1	1633	January 15, 2018
What is the correct way to Order Transactions on the Bank or Payments Tab Uncategorized	34	2220	February 26, 2020

Import bank Statement Question

Related topics