I need the invoice items in a report export

[MacITArk]

I get all the details I need in a transaction export, EXCEPT the invoice items. I understand that's a many-to-one relationship to the invoice, so if we could get a separate report that has the invoice_UID with the line items, I can put them back together.  This would save me an enormous amount of work at tax time. 

[LLCafe]

Hi @MacITArk,

I think you can achieve what you are looking for by doing the following on the Transactions Screen on Square Dashboard.

1. Filter by Source using Invoices as the Source
2. Click Export
3. Then Choose Items Detail CSV

When I do that it lists all of the items on each invoice and gives the Transaction ID so you can see which transactions go with which invoice.

Hopefully that helps!

[JJ_]

Thank you for taking the time to submit your feature request @MacITArk Please see @LLCafe reply on how to accomplish this.

[sclhtim]

@JJ_ @LLCafe 

I was hoping this would be a workaround for my use case, but it does not work when dealing with partially paid invoices.

Partially paid invoices show up in the transactions report, but do not appear in the Items Detail CSV. This means there is no way to know what the partial payment was for without manually looking up the invoice.

My issue:

Right now, when a customer partially pays an invoice, the money is deposited into our bank account, but there is no report that our accounting department can pull that shows where that money came from. 

What are we supposed to do when we are audited but have no way to account for thousands of dollars in our bank account?

We need an option to record partial payments as sales or partial sales.

Use case:

We sell advertising in our magazine. When an advertiser signs a year-long contract, they have the option to pay quarterly. To do this, we add milestones to the invoice so that the advertiser is billed quarterly for 25% of the invoice total.

I need a way for these partial payments to report as sales for the item in question. For example a partial payment toward a full-page ad should report as a sale of a full-page ad for the partial payment amount when that payment is received.