# How to set lines account in batch create journal entry

**URL:** <https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575>\
**Category:** Uncategorized\
**Created:** [August 17, 2021, 11:23am UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575 "2021-08-17T11:23:39Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashrafsoliman](https://avatars.discourse-cdn.com/v4/letter/a/a9adbd/32.png) [@ashrafsoliman](https://forum.manager.io/u/ashrafsoliman)\
**Post date:** [August 17, 2021, 11:23am UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/1 "2021-08-17T11:23:39Z")

</div>

how to set lines account in batch create journal entry

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [August 17, 2021, 11:37am UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/2 "2021-08-17T11:37:06Z")

</div>

The Lines.Account contains the key to the accounts you want to post the entry to

Each cell can contain one or more entries - you can use Batch Update to see what entries you will need

But why do you want to use Batch Create to enter journal entries - journal entries are rarely needed in Manager?

For example, this one has 12 entries

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/9/59711d0766f105847c62eaf46be57fceb0686baf.png)

---

<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:** [August 17, 2021, 11:41am UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/3 "2021-08-17T11:41:30Z")

</div>

You need to place a carriage return (CR) and a line feed (LF) between each UUID in a single cell. You will also need to do that for every line field including the amount.

Practically, you can insert the following formula fragment to separate lines within a single cell:

```auto
& char(13) & char(10) &

```

---

<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:** [August 22, 2021, 1:41pm UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/4 "2021-08-22T13:41:30Z")

</div>

Split this topic on August 22, 2021, 1:41pm UTC

A post was split to a new topic: [Import chart of accounts](https://forum.manager.io/t/import-chart-of-accounts/36642)

---

<div class="post-metadata">

**Author:** ![septian](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@septian](https://forum.manager.io/u/septian)\
**Post date:** [December 14, 2024, 7:04am UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/5 "2024-12-14T07:04:28Z")

</div>

> [@Ealfardan](#):
>
> ou need to place a carriage return (CR) and a line feed (LF) between each UUID in a single cell. You will also need to do that for every line field including the amount.
> 
> Practically, you can insert the following formula fragment to separate lines within a single cell:

can you record step how to do it? i dont understand please

---

<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:** [December 15, 2024, 11:42am UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/6 "2024-12-15T11:42:41Z")

</div>

This is no longer how batch create works. Separate lines are now encoded as separate columns. To test this you can create a Journal Entry and Batch update it to see the new structure.

---

<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:** [July 5, 2026, 8:19pm UTC](https://forum.manager.io/t/how-to-set-lines-account-in-batch-create-journal-entry/36575/7 "2026-07-05T20:19:01Z")

</div>

Closed on July 5, 2026, 8:19pm UTC

Uncategorized topics older than 3 years with no recent activity
