Import Bank Account

#1

Hi,

When import bank statement in CSV format the “Payee / Payer” column would update “Payer” type to “Other” and put the text alongside it. Since upgrade to 21.1.11 the csv import does not update as it used to. My columns are Date Payee Reference Description Amount.

#2

Can you illustrate this with screen shots?

#3

Thank you for your response.

The new version does not update the Payer field and description as it used to in the older version.

Diets Nieuwoudt.

CSV file Input

image001.png

Screenshot of previous interface

image003.jpg

Second screenshot using same file format, just changed the date so as not to duplicate:

image007.jpg

#4

When was the statement that led to your 23.02.2019 payment imported? Based on the date, it was before the classification of payer/payee as Customer/Supplier/Other was implemented. So looking at that transaction now, it would default to Other.

#5

Thank you for your prompt response!

I cannot remember the exact date, but the CSV file was created on 12 July 2019.

My I please ask the format of the CSV to allow me to use the Customer/Supplier/Other import?

Also, please accept my full appreciation and gratitude for a brilliant piece of software. I firmly believe you are changing millions of lives, and saving millions of dollars (or whatever currency) for you users.

Kind regards,

Diets Nieuwoudt

#6

Hi,

I have not heard from you again. Should I just accept that the functionality present in last year’s version - where importing a bank statement CSV file updated the Payer Type to “Other” and carried the “Payee” text from the csv file as part of the import - is no longer available. If that is the case, may I request suggestions on how to do it with the present release?

Thank you.
Diets

#7

Batch import requires use of the format and columns specified for the version of Manager you are using.

Manager receipt / Payment tab has been upgraded during the last year. The enhanced functionality is also seen in the batch create / update interface.

To understand the enhanced interface use batch update and look at records similar to what you want to create. Then create appropriate entries for batch create.

Btw linking to customer/ supplier entries will enable Manager to provide reports simply not possible with the old free text names. Embracing it now is likely to enhance your businesses management in the future.

#8

Patch

Thank you for your response. I am trying to create a batch input that will complete these fields in the Payment Capture.

image003.jpg

What I basically need is an explanation on how to map the batch input fields to the fields on the capture screen



Type


Date


Reference


BankAccount


Description


Lines.Item


Lines.Account


Lines.MemberAccount


Lines.BillableExpenseCustomer


Lines.BillableExpenseSalesInvoice


Lines.Invoice


Lines.Description


Lines.Qty


Lines.Amount


Lines.Discount


Lines.DiscountAmount


Lines.Debit


Lines.Credit


Lines.TaxCode


Lines.TrackingCode


Lines.ProposedAccountAmount


Lines.CustomFields


Lines.CustomerOrSupplier


Contact


BankClearDate


BankClearStatus


InventoryLocation


AmountsIncludeTax


CustomTheme


Theme


AutomaticReference


HasPaymentCustomTitle


PaymentCustomTitle


HasReceiptCustomTitle


ReceiptCustomTitle


PayerPayeeType


Customer


Supplier

Diets

#9

That is why you look at batch update first.

If your businesses has too much data you can

  • look first at a test businesses.

  • Enter a selection of data to illustrate the range of entries you intend to batch import.

  • Enter text in each field you can readily identify.

  • Do a batch update and it will demonstrate the format required

#10

Thank you. All you needed to say was “use UUID / GUID” and you would have saved me hours. Also the Date format must dd-Mmm-yyyy eg. 17-Mar-2020