# Can i enter purchase invoice withe excel

**URL:** <https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991>\
**Category:** Uncategorized\
**Created:** [July 14, 2022, 1:43pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991 "2022-07-14T13:43:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![MCasper](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@MCasper](https://forum.manager.io/u/MCasper)\
**Post date:** [July 14, 2022, 1:43pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991/1 "2022-07-14T13:43:18Z")

</div>

i have an excel invoice that has more than 150 item i already enter the item code and price in the inventory but i need help with import the invoice if it possible

---

<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 14, 2022, 3:07pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991/2 "2022-07-14T15:07:59Z")

</div>

You need to use the batch create function.

All the fields of a single invoice should be contained in 1 row, with lines separated by a carriage return `char(13)` followed by a line feed `char(10)`.

In newer versions of excel, you can use the following formula to combine multiple lines in a single cell:

```auto
=TEXTJOIN(CHAR(13)&CHAR(10),FALSE, ...)

```

Heads up! This isn’t a trivial task by any means and requires a certain level of spreadsheet skills in order pull off successfully. But it’s not the hardest thing in the world.

Which begs the question: why do you create external invoices and then copy them to Manager? Why not create them in Manager to begin with?

This seems to defeat the whole purpose of using an accounting software.

---

<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:** [July 14, 2022, 3:59pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991/3 "2022-07-14T15:59:08Z")

</div>

> [@Ealfardan](#):
>
> This seems to defeat the whole purpose of using an accounting software.

That was my thought, exactly. Creating a purchase invoice via Batch Create would be harder than doing it manually, considering all the spreadsheet manipulation you would have to perform.

---

<div class="post-metadata">

**Author:** ![MCasper](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@MCasper](https://forum.manager.io/u/MCasper)\
**Post date:** [July 15, 2022, 8:28pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991/4 "2022-07-15T20:28:54Z")

</div>

thanks a lot i will tray it  
as i said it is a purchase invoice so i get it like this and i ask if there a way to be easy for me

---

<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:** [July 15, 2022, 9:10pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991/5 "2022-07-15T21:10:55Z")

</div>

> [@MCasper](#):
>
> if there a way to be easy for me

Was your purchase preceded by a purchase order? If so, you can simply copy the purchase order to a purchase invoice. See the Guide: [https://www.manager.io/guides/7262](https://www.manager.io/guides/7262).

---

<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:12pm UTC](https://forum.manager.io/t/can-i-enter-purchase-invoice-withe-excel/41991/6 "2026-07-05T20:12:45Z")

</div>

Uncategorized topics older than 3 years with no recent activity