# Cash Book Import

**URL:** <https://forum.manager.io/t/cash-book-import/48908>\
**Category:** Uncategorized\
**Created:** [September 13, 2023, 6:34am UTC](https://forum.manager.io/t/cash-book-import/48908 "2023-09-13T06:34:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tanje\_Britz](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tanje_britz/32/27897_2.png) [@Tanje\_Britz](https://forum.manager.io/u/Tanje_Britz)\
**Post date:** [September 13, 2023, 6:34am UTC](https://forum.manager.io/t/cash-book-import/48908/1 "2023-09-13T06:34:56Z")

</div>

Good day i am struggling to import the \*CSV file

Headers & formats are correct.

Receiving this error

Header with name ‘Date’ or ‘Transaction Date’ or ‘TransactionDate’[0] was not found. Header with name ‘Amount’ or ‘Credit’ or ‘Credits’ or ‘Credit Amount’ or ‘Net’ or ‘In amount(R)’[0] was not found. Headers: ‘DATE’, ‘REFERENCE’, ‘DESCRIPTION’, ‘AMOUNT’ Headers: ‘DATE’, ‘REFERENCE’, ‘DESCRIPTION’, ‘AMOUNT’ Headers: ‘DATE’, ‘REFERENCE’, ‘DESCRIPTION’, ‘AMOUNT’ Headers: ‘DATE’, ‘REFERENCE’, ‘DESCRIPTION’, ‘AMOUNT’ If you are expecting some headers to be missing and want to ignore this validation, set the configuration HeaderValidated to null. You can also change the functionality to do something else, like logging the issue. IReader state: ColumnCount: 0 CurrentIndex: -1 HeaderRecord: [“DATE”,“REFERENCE”,“DESCRIPTION”,“AMOUNT”] IParser state: ByteCount: 0 CharCount: 38 Row: 1 RawRow: 1 Count: 4 RawRecord: DATE,REFERENCE,DESCRIPTION , AMOUNT

Format of the \*CSV file

DATE REFERENCE DESCRIPTION AMOUNT

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64196_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [September 13, 2023, 6:46am UTC](https://forum.manager.io/t/cash-book-import/48908/2 "2023-09-13T06:46:52Z")

</div>

Is the CSV file comma or tab delimited? We use comma delimited. Make sure that the first line is something similar to:

Date,Reference,Description,Amount

An example of 3 records including the header is below, try to import that into a test business (create a test business and enable bank and cash accounts, receipts and payments in Customize):

Date,Reference,Description,Amount  
01/04/2022,0,ACCOUNT MAINTENANCE CHARGE,-5388.18  
01/04/2022,0,VALUE ADDED TAX,-404.11  
01/04/2022,0,TRANSFER BETWEEN CUSTOMERS Via USSD Bank Transfer

Note that you need to have separate lines for each transaction

---

<div class="post-metadata">

**Author:** ![Tanje\_Britz](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tanje_britz/32/27897_2.png) [@Tanje\_Britz](https://forum.manager.io/u/Tanje_Britz)\
**Post date:** [September 13, 2023, 10:39am UTC](https://forum.manager.io/t/cash-book-import/48908/3 "2023-09-13T10:39:11Z")

</div>

Thank you for your response

In the past 4 years have always been able to import file type “Microsoft Excel Comma Separate Values File” I am not doing anything different so i am very confused

The headers are correct

Transactions on different

lines

I have uploaded a sample of what i have done in the past but am struggling with now

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64196_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [September 13, 2023, 11:48am UTC](https://forum.manager.io/t/cash-book-import/48908/4 "2023-09-13T11:48:37Z")

</div>

Please deleted the PDF is a potential user hazard.

It contains:

DATE REFERENCE DESCRIPTION AMOUNT  
01 03 2023 NED/C-001 C_AUTOWASH GRE5181030003601496 -300  
01 03 2023 NED/C-002 C_Makro Germis5181030003601496 -119  
01 03 2023 NED/C-003 CARTRACK 674280-145.26  
01 03 2023 NED/C-004 Checkers Green377121713647682 -367.78  
01 03 2023 NED/C-005 DIS-CHEM GREEN377121713647682 -580.22  
01 03 2023 NED/C-006 DIS-CHEM GREEN377121713647682 -443.9  
01 03 2023 NED/C-007 DIS-CHEM GREEN377121713647682 -310.95  
01 03 2023 NED/C-008 Instant payment fee -49  
01 03 2023 NED/C-009 Praise Salary -500  
01 03 2023 NED/C-010 Tanje monthly contribution Feb **-25 060.23**  
01 03 2023 NED/C-011 WOOLWORTHS **PL 377121**

There are space delimiters and the Woolworths one and Tanje one can not be red properly so will create an error in Ecell.

Please change to comma delimited as below and try to import. Correct the Woolworths one.

DATE,REFERENCE,DESCRIPTION,AMOUNT  
01/03/2023,NED/C-001,C_AUTOWASH GRE5181030003601496 -300  
01/03/2023,NED/C-002,C_Makro Germis5181030003601496 -119  
01/03/2023,NED/C-003,CARTRACK 674280-145.26  
01/03/2023,NED/C-004,Checkers Green377121713647682,-367.78  
01/03/2023,NED/C-005,DIS-CHEM GREEN377121713647682,-580.22  
01/03/2023,NED/C-006,DIS-CHEM GREEN377121713647682,-443.9  
01/03/2023,NED/C-007,DIS-CHEM GREEN377121713647682,-310.95  
01/03/2023,NED/C-008,Instant payment fee,-49  
01/03/2023,NED/C-009,Praise Salary,-500  
01/03/2023,NED/C-010,Tanje monthly contribution Feb -25, 060.23  
01 03 2023,NED/C-011,WOOLWORTHS PL,377121

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [September 13, 2023, 6:10pm UTC](https://forum.manager.io/t/cash-book-import/48908/5 "2023-09-13T18:10:16Z")

</div>

@Tanje_Britz, your link to a PDF was deleted because it was a security risk for other users. Post information directly.
