Receipt batch create too large to manipulate prior to import

1

Hi,

I wish to know if I’m using the Receipt function correctly. I sell on Walmart and I get a payment once a month. The payment record is a CSV file with about 5000 rows that contains payments, refunds, deductions like advertising and shipping fees. Am I supposed to use the Receipt function to “recreate” this payment record, like the picture below?

receipt
receipt754×524 53.4 KB

I would use Excel to manipulate the CSV file to match the Batch Create format. This works until the CSV gets too large because:

  1. As I add more Lines.*.[Header] columns to the output, I exceed the 16,384 column limit for a workbook
  2. If I try to load the output to Excel data model, my PC runs out of memory.

The reason I put everything into Receipt is because I want the amount on the receipt to match the amount I receive into my bank. Should I split the CSV file so that only the gross payment go into Receipt and the deductions go into Payment?

1 Like
2

I don’t understand what you are trying to achieve

Why do you need to import all the detail into Manager?

Just enter the totals

2 Likes
3

I enter the details because I want to see if each order got paid. Entering the invoice number for each line marks the invoice as Paid in the invoice status. I had bad experience with Walmart skipping payments on some invoices.

I suppose I can aggregate the expenses into category rather than having them match a PO number, that would eliminate a lot of columns and rows.

1 Like
4

I agree you need to make sure that Walmart is paying you for all your orders.