# Bulk Importing of invoice line items **URL:** \ **Category:** Uncategorized\ **Created:** [November 23, 2022, 1:31pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173 "2022-11-23T13:31:07Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dsscairtourer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/dsscairtourer/32/23299_2.png) [@dsscairtourer](https://forum.manager.io/u/dsscairtourer)\ **Post date:** [November 23, 2022, 1:31pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/1 "2022-11-23T13:31:07Z")
Hi, I am using manager (Desktop) for our local Aero Club. We sell fuel through an automated bowser and receive a downloadable file with all transactions by Customer No, Fuel Type, Date Reference No. I have the option of a CSV or XLS which are easily formatted into the formats used in invoicing. Is there any way I can bulk import them onto customer invoices at month’s end to save manually entering each sale? I use a monthly Omni invoice for each customer showing each purchase as a seperate line item by date and reference No. etc. There are only two types of fuel sold. This feature would be a big time saver and eliminate transcribing errors. Any suggestions will be most welcome. ---
**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:** [November 23, 2022, 3:12pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/2 "2022-11-23T15:12:08Z")
You need to create a sample invoice in Manager with a few lines, then use the Batch Update feature to see how the Excel spreadsheet has to be formatted. ---
**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:** [November 23, 2022, 3:17pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/3 "2022-11-23T15:17:06Z")
> [@dsscairtourer](#): > > Is there any way I can bulk import them onto customer invoices at month’s end Yes. The actual invoices are created using Batch Create. Read the Guide about that. ---
**Author:** ![Panashe\_Mlambo](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/panashe_mlambo/32/27658_2.png) [@Panashe\_Mlambo](https://forum.manager.io/u/Panashe_Mlambo)\ **Post date:** [November 23, 2022, 3:27pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/4 "2022-11-23T15:27:26Z")
> [@dsscairtourer](#): > > I use a monthly Omni invoice for each customer showing each purchase as a seperate line item by date and reference No. etc. Do your customers pay by card/cash when they buy the fuel? If so then the reports that you extract you can record them as cash sales If they buy on account then what @Tut is suggesting will help. [https://www.manager.io/guides/9572](https://www.manager.io/guides/9572) ---
**Author:** ![Mark](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mark](https://forum.manager.io/u/Mark)\ **Post date:** [November 23, 2022, 5:22pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/5 "2022-11-23T17:22:15Z")
Do you think it is wise to publish your email address on a public forum? ---
**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:** [November 23, 2022, 7:18pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/6 "2022-11-23T19:18:20Z")
@dsscairtourer, your email was deleted. Including personal information violates the rules of the forum. ---
**Author:** ![dsscairtourer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/dsscairtourer/32/23299_2.png) [@dsscairtourer](https://forum.manager.io/u/dsscairtourer)\ **Post date:** [November 24, 2022, 12:01am UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/7 "2022-11-24T00:01:08Z")
Thanks for the warning, I am new to the forum and didn’t think. I realized after posting that I was already identified as dsscairtourer. ---
**Author:** ![dsscairtourer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/dsscairtourer/32/23299_2.png) [@dsscairtourer](https://forum.manager.io/u/dsscairtourer)\ **Post date:** [November 24, 2022, 12:04am UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/8 "2022-11-24T00:04:38Z")
Hi Tut, I am new to posting on the forum and didn’t think. I realized after posting it that I was identified as dsscairtourer automatically. Should I repost my article or is it still there minus my Email? Thanks in advance. ---
**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:** [November 24, 2022, 12:52am UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/9 "2022-11-24T00:52:42Z")
Only your email address was removed from the earlier post. You can see for yourself in this thread what is visible to other forum members. Your last post was also edited to remove your name. The forum is anonymous. Please read the FAQ. [FAQ - Manager Forum](https://forum.manager.io/faq) ---
**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:09pm UTC](https://forum.manager.io/t/bulk-importing-of-invoice-line-items/44173/10 "2026-07-05T20:09:28Z")
Uncategorized topics older than 3 years with no recent activity