Importing bank payments and deposits from a cvs and then creating invoices

1

I need to import the file and then convert the imported payment into a paid invoice. How do I do this?

I need to record payments and deposits as invoices. After importing the bank file, I can’t convert some payments into invoices. How do I fix this problem?

Thank you.

2

You cannot do that

Why would you?

3

Everything would be faster.

What do you do if you’ve imported payments from CVS and need to record invoices for those payments?

Do you create an invoice, manage the payment, and then delete the payment from CVS?

How do you create your invoice and record the payment from the imported CVS file so it’s reconciled?

Thanks.

4

Why do you want to create in invoice at all ?

There is no need to create a Sales Invoice. The payment transaction is sufficient for your accounting needs - just post it to an income account such as Sales or whatever income account is appropriate

1 Like
5

I’m required to keep an invoice book.

Do you understand the problem now?

Thank you.

6

Perhaps you could give more details of your business?

What country are you doing business in?

It’s a bit painful to have to extract all this information bit by bit

7

Hi @CARLOS_LOPEZ,

What you are requesting is to do the invoicing process in reverse – which is an edge case that makes no sense from a software development standpoint.

I’m not aware of any other software that creates invoices retrospectively based on payments since at that point in time all control benefits are past due.

I’m not dismissing your use case at all, but I need to be fully honest with you.

Let’s take a step back and examine your objective:

Could this be achived by:

  • Keeping a reference of your purchase invoice number and date somewhere on your payment?

  • Changing the title of your Payments to, say, Cash Invoice?

If not, why not use Batch create to import your purchase invoices at one go?

8

I think he is talking about payments by customers but maybe I’m wrong

9

Payments & receipts can be renamed “Tax invoice” which maybe sufficient. Currently these transactions are not included in the supplier or customer transaction ledger but that’s in the ideas from memory.

1 Like
10

Thanks, Ealfarda.

I’m working on the invoice. It would make more sense to create it and then import the CVS file with the payments.

Please, how can I import all the purchase invoices at once? Create them in batches? Can you give me an example?

11

In order to learn more on Batch Create/Batch Update functions you can refer to this guide:

Also, to make your life easier, I recommend that you first start with coding your records that are going to be referenced in transactions. For example:

  • Customers and/or Suppliers
  • Inventory Items, Non-inventory Items and/or Chart of Account entries

Tax code name is already its code, so nothing is required.

This isn’t necessary, but it avoids relying on system generated UUIDs, which are a bit harder to use.