# Problem with "Batch Create"

**URL:** <https://forum.manager.io/t/problem-with-batch-create/26078>\
**Category:** Uncategorized\
**Created:** [January 2, 2020, 8:21pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078 "2020-01-02T20:21:58Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed\_Hammam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmed_hammam/32/22857_2.png) [@Ahmed\_Hammam](https://forum.manager.io/u/Ahmed_Hammam)\
**Post date:** [January 2, 2020, 8:21pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/1 "2020-01-02T20:21:58Z")

</div>

When I import a file that contains customer names and opening balances for them, the balances appear negative, How do I solve that problem?

---

<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:** [January 2, 2020, 8:27pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/2 "2020-01-02T20:27:42Z")

</div>

You have not provided enough information to answer your question. Import from where? Import to where? Describe exactly what you are doing, step by step. Illustrate your situation with screen shots.

---

<div class="post-metadata">

**Author:** ![Ahmed\_Hammam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmed_hammam/32/22857_2.png) [@Ahmed\_Hammam](https://forum.manager.io/u/Ahmed_Hammam)\
**Post date:** [January 2, 2020, 8:33pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/3 "2020-01-02T20:33:15Z")

</div>

![q1](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/e/0e20850710ddfc3f9dedfdd72f62080f3aa75432.png) ![q2](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/e/ce5c42d6d613c0180a46a834bd60f372f4cda327.png) ![q3](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/b/5b78ad1f5f0b2830c4a42b6010a8b265a8d2049a.png)

---

<div class="post-metadata">

**Author:** ![Ahmed\_Hammam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmed_hammam/32/22857_2.png) [@Ahmed\_Hammam](https://forum.manager.io/u/Ahmed_Hammam)\
**Post date:** [January 2, 2020, 8:41pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/4 "2020-01-02T20:41:16Z")

</div>

i created new business and i wanted to import the names of clients and their opening balances from the Excel file, so the balances appeared negative

---

<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:** [January 3, 2020, 1:24am UTC](https://forum.manager.io/t/problem-with-batch-create/26078/5 "2020-01-03T01:24:10Z")

</div>

You cannot import starting balances that way, because the customer form does not include a starting balance field. Starting balances for customers must be entered as described in this Guide: [Set starting balances for customers | Manager](https://www.manager.io/guides/5494).

---

<div class="post-metadata">

**Author:** ![Ahmed\_Hammam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmed_hammam/32/22857_2.png) [@Ahmed\_Hammam](https://forum.manager.io/u/Ahmed_Hammam)\
**Post date:** [January 3, 2020, 1:40pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/6 "2020-01-03T13:40:38Z")

</div>

I followed the method in the guide, and the problem still exists, the balances appear negative and if i try to enter it negative, the customer’s balance appears in the account the number “zero”

---

<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:** [January 3, 2020, 2:24pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/7 "2020-01-03T14:24:04Z")

</div>

@Ahmed_Hammam, you have not said where the balances appear negative. I assume you mean in the accounts receivable column for the customer under the Customers tab or in a drill-down on the _Accounts receivable_ account in the Summary.

You seem to be referring to amounts entered in the `Available credit` field for a customer, which you see after clicking Edit for that customer while setting starting balances for _Accounts receivable_. The reason the number you enter there shows as negative is because it is a credit, meaning you owe the customer money that is not associated with any sales invoice or other transaction. This is explained in the Guide I linked to above. Since _Accounts receivable_ is a debit account, credits move its balance in the negative direction. Negative numbers are ignored because those would not be credits, but debits.

When a customer owes you money, that must be associated with a sales invoice. You must enter those as unpaid invoices that predate the start date. Again, this is explained in the Guide.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 2:47pm UTC](https://forum.manager.io/t/problem-with-batch-create/26078/8 "2023-01-18T14:47:03Z")

</div>

Closed on January 18, 2023, 2:47pm UTC


