# Bulk Receipt from Bank

**URL:** <https://forum.manager.io/t/bulk-receipt-from-bank/32557>\
**Category:** Uncategorized\
**Created:** [January 13, 2021, 6:42am UTC](https://forum.manager.io/t/bulk-receipt-from-bank/32557 "2021-01-13T06:42:15Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [January 13, 2021, 7:29am UTC](https://forum.manager.io/t/bulk-receipt-from-bank/32557/4 "2021-01-13T07:29:12Z")

</div>

use `VLookUp` to convert the customers name to GUID  
See

> [@Batch creation of receipts from invoices](https://forum.manager.io/t/batch-creation-of-receipts-from-invoices/30985/4):
>
> Here’s a workaround you could use, while Customer UUIDs still need to be used for batch-create operations: For every one of your customers, enter their name (or another ID that consistently shows on your monthly csv) into the Manager Customer ‘Code’ field or into a "Custom Field’ In a spreadsheet, create a customer-ID table of all the previously entered IDs against their Manager UUIDs (Customer batch-update/copy-to-clipboard), save and backup the file Compile a batch-create table, using…

But you may need to employ a programmer to set this up for you if you don’t have the programming skills.

---

_[View the full topic](https://forum.manager.io/t/bulk-receipt-from-bank/32557)._