# Copy format for receipt-or-payment-batch-operations

**URL:** <https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213>\
**Category:** Uncategorized\
**Created:** [May 13, 2020, 1:05pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213 "2020-05-13T13:05:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kendirangu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/kendirangu/32/28783_2.png) [@kendirangu](https://forum.manager.io/u/kendirangu)\
**Post date:** [May 13, 2020, 1:05pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213/1 "2020-05-13T13:05:22Z")

</div>

Hello  
I need to copy the data on receipts and payments onto a spreadsheet.  
I note that the data pastes out with all the data in a single column. Please assist. This is for manager desktop 20.2.31

---

<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:** [May 13, 2020, 1:19pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213/2 "2020-05-13T13:19:46Z")

</div>

Your post is not clear. How are you copying the data? And what data are you copying? Are you copying the tab listing itself? Are you exporting the tab listing? Are you using the Copy to clipboard button during a Batch Update process?

Then, exactly how and where are you pasting the data? Whatever problem you are experiencing is most likely a function of your spreadsheet, not Manager.

Finally, you should update your software. You are more than 100 versions behind.

---

<div class="post-metadata">

**Author:** ![kendirangu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/kendirangu/32/28783_2.png) [@kendirangu](https://forum.manager.io/u/kendirangu)\
**Post date:** [May 13, 2020, 1:28pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213/3 "2020-05-13T13:28:52Z")

</div>

I am using the copy to clipboard button. I paste into excel, i see the data but all are in one column. For example this is my 1st cell below.

“Date BankAccount Description Lines.Description Lines.Account Lines.TaxCode Lines.Qty Lines.Item Lines.Amount Lines.Debit Lines.Credit Lines.Discount Lines.TrackingCode Lines.ProposedAccountAmount Lines.CustomFields Lines.DiscountAmount Lines.MemberAccount Lines.BillableExpenseCustomer Lines.BillableExpenseSalesInvoice Lines.Invoice Contact BankClearDate BankClearStatus InventoryLocation AmountsIncludeTax CustomTheme Theme Type Reference AutomaticReference HasPaymentCustomTitle PaymentCustomTitle HasReceiptCustomTitle ReceiptCustomTitle Key”

---

<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:** [May 13, 2020, 2:11pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213/4 "2020-05-13T14:11:47Z")

</div>

Your result is a function of how you are pasting into Excel. Options vary extensively by software edition and version, operating system, region for which your software is licensed, etc. Consult Excel Help to understand your Paste options.

---

<div class="post-metadata">

**Author:** ![kendirangu](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/kendirangu/32/28783_2.png) [@kendirangu](https://forum.manager.io/u/kendirangu)\
**Post date:** [May 13, 2020, 8:11pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213/5 "2020-05-13T20:11:46Z")

</div>

Apologies. Problem solved. I restarted Excel.  
I have also upgraded to the latest version as adviced.

---

<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:46pm UTC](https://forum.manager.io/t/copy-format-for-receipt-or-payment-batch-operations/28213/6 "2023-01-18T14:46:54Z")

</div>

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


