Hi Erin

Can you please paste a screenshot of the error message in this chat?

Also, are you aware of the Bank Manager module that allows you to import bank statements in a far easier way into your Evolution company?

If you go to Help | About within the Evolution company, don't you perhaps see a module called Bank Manager 2?

Kind regards

Bennie 

Hi Bennie,

Thanks for the quick reply!

I tried attaching the screenshot but it seems to be to large :/ I am aware of the Bank Manager module, however, the company I'm trying to upload the cashbook for has been doing it on excel for the last 6 years so that means I would need to reallocate 6 years of data to the correct accounts which I'd like to avoid if I can upload it through a cashbook batch with the correct account already entered.

Hope that makes sense..

Thanks,
Erin

You're welcome,  Erin

Please send me a list of all the fields that you need in your cashbook batch import template.

I'll then create and test it before sending you the template file. 

Morning Bennie,

I figured out how to resize the image of the error I got

The columns I need to be able to populate in the cashbook batch are:

Date

Module

Account

Account Name

Reference

Description

Deposit

Payment

Tax

Tax Account

Let me know if you need more info!

Kind regards,

Erin

TxDate,Description,Reference,Amount,UseTax,TaxType,TaxAccount,TaxAmount,Project,Account,IsDebit,SplitType,SplitGroup,Reconcile,PostDated,UseDiscount,DiscPerc,DiscTrCode,DiscDesc,UseDiscTax,DiscTaxType,DiscTaxAcc,DiscTaxAmt,PayeeName,PrintCheque,SalesRep,Module,Property,Portion,Service,Meter,Override,SagePayExtra1,SagePayExtra2,SagePayExtra3
17/04/2024,DESC001,REF001,1000,N,,,0,,ABC,Y,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,,
30/04/2024,DESC002,REF002,1500,N,,,0,,DELTA,Y,0,0,N,N,N,0,,,N,,,0,,N,,1,,,,,N,,,
22/04/2024,DESC003,REF003,2000,N,,,0,,DAKU,Y,0,0,N,N,N,0,,,N,,,0,,N,,2,,,,,N,,,
27/04/2024,DESC004,REF004,3000,Y,1,Vat Control,586.957,,Advertising,N,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,,
27/04/2024,DESC005,REF005,4000,Y,1,Vat Control,443.478,,Bank Charges,Y,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,,
27/04/2024,DESC006,REF006,5000,N,,,0,,RCM,N,0,0,N,N,N,0,,,N,,,0,,N,,2,,,,,N,,,
27/04/2024,DESC007,REF007,6000,Y,1,Vat Control,39.13,,Consulting,Y,0,0,N,N,N,0,,,N,,,0,,N,,0,,,,,N,,,

Thanks, Erin

Do the following to resolve your query:

1. Find attached a file called CB005 Cashbook Batch IMPORT.txt. Copy it to your local PC.

2. Rename it to CB005 Cashbook Batch IMPORT.csv

3. Open the CSV file and note the following:

a) Don't delete any columns even if you're not using them. I tested the template as it is and it works just fine to import into the cashbook. Perhaps you can delete one or two columns but then you need to test the effect of doing so....... 

b) Keep all columns in the same order/sequence. As you would have realized, there is no Field Mapping feature in the import screen, therefore keep all columns as they are.

c) Add as many rows as required for all your transaction lines. 

d) Substitute the Amount and other required columns (e.g. Reference, Description, etc.)  values in the various rows

e) Column K -  Is Debit: Y = a deposit amount, N = Payment amount

f) Column AA - 0 = Gl, 1 = AR, 2 = AP

g) Column A - Tx Date: I'm using dd/mm/yyyy on my PC's regional Settings and therefore 

   g1) Ensured the Short Date Format on the import file = dd/mm/yyyy

   g2) Selecte the Windows Format option below 

4. When done editing the import file, ensure it's saved as a CSV file format and then close it.

5. In the Cashbook batch, ensure all transaction lines are cleared (having no transaction lines and save the batch

6. Go to File | Import and browse for the import file, and import it. (see my options above in g2)

Please advise if you're successful or not

Hi Bennie,

Thanks, it wouldn't work the first time with all (GL, AR, AP) modules entered so I tried an upload with each module separately i.e. only GL, then only AR and then AP. The csv upload worked for the GL and AR modules but I still get the same error as before when I try to import AP module lines. 

It seems to be just the opposite error I had when trying to export the cashbook template. I've attached the screenshot of the import error I got this time. 

Hi Erin

What is your Evolution version and build?

Hi Bennie,

We've got version 11.0.4.0 :)

Thanks, Erin

According to a previous query we had from a different client, the error was resolved by simply closing the Evolution company and re-opening it.

Have you already done that?

And have you used the import template I sent you?

If yes on both, please provide me with your e-mail address so I can then send you a MS Teams meeting invite to have a closer look at your import query.

Blessings!

Bennie 

Morning Bennie,

Yes to both :) Is there a way that I can privately share my email address with you please? Not a fan of leaving my email address on an open forum..

Thanks, Erin

Certainly.

Send me a Friend Request in the Community Hub.

We'll then continue to correspond in a private chat in the Community.