Is anyone else out there still having problems with the report generator? My columns still do not line up correctly, as a result my net profit is showing up as the total of the bid plus shipping.

My question is - is there a way to move the margins to the left. I noticed when I ran the report for 1 auction, the REAL net profit is placed right below the FALSE net profit - if this can be fixed we could actually USE the reports - unless of course - I am the only one who CANNOT use them right now - anyone?

The "Generate Report" function has never worked properly. The calculations are all wrong. I have reported this since 3.00 was released and here we are at 3.07 and it still doesn't work. Amazing that such a simple thing has never been included in any of the updates. As I have said before, it's simple spreadsheet accounting. I have given up on it and now use the "Export to comma delimited file" to export my records to Excel. If I recall correctly only one other person has ever mentioned this as a problem here in this forum. I guess that's not enough for support to consider it a real problem. Too bad....it would be a real time saver it you could rely on the calculations to be correct.

What is it about the calculations that are incorrect? I though you just wanted the misc fees to have a column in the report?

Let me know what is still incorrect about it and it will be fixed.

miles

Miles - for me the net profits and the final totals are not calculating correctly. It adds the bid amount and the shipping, no matter how I edit the report settings. I cannot get the real net profit unless I manually calculate it and write it next to the item. I have pasted a copy of two auctions generated from the report. (notice NP in all three lines)
bid ship cost ebay net profit
40.17 2.97 18.00 2.83 43.14
15.51 2.98 9.90 0.80 18.49

$55.68 $5.95 $27.90 $3.63 $24.15

Thanks -

Whoops Miles - sorry the spacing is off on the post, I didn't realize they would show up so close together, the shipping $ are correct, they are from a combined winning auction.

Also, Hapa01 - I found that exporting to the comma delimited file requires a lot of data clean-p, can you provide me with some tips on how you managed the data clean-up? I would appreciate your advice...

Well for one thing, as I've said before, there needs to be an option for selecting "pay service fees" for the "report settings". Pay service fees are on the ebud spreadsheet but cannot be included on the "generate report".

Secondly, on individual items in the report, pay sevice fees are not being reflected in the "gross expenses" column but they are being reflected in the "net profit" column. So if you subtract "gross expenses" from "gross receipts" you don't get what's in the "net profit" column.

Thirdly, the column headed "Shipping is not adding the figures correctly. As an example I generated a report for 7 items. The shipping for theses items is:
4.35
4.35
4.35
4.35
5.60
.57
.57
for a total of 24.14. The report shows a total of 19.79. It left out one of the 4.35 figures. If the integrity of the data can't be trusted for as small a sampling of 7 items, how can it be trusted for a months worth of auctions. Who has the time to go through a report and re-check all the figures for math mistakes?

[This message was edited by hapa01 on April 04, 2002 at 09:17 AM.]

quote:

---

Originally posted by jcrbfam:

Also, Hapa01 - I found that exporting to the comma delimited file requires a lot of data clean-p, can you provide me with some tips on how you managed the data clean-up? I would appreciate your advice...

---

Yes, there is alot of clean-up. That's why it would be so great to have the report function in ebud working. When I export to Excel, rather than try to delete the data I don't need during the export process, I just export everything to a new excel spreadsheet and then copy and paste the info I need onto my "real" spreadsheet.

Thanks hapa01 - I end up spacing everything then rerun the parameters of the file. It is also a lot of work. Miles - any clue as to what could be wrong? It still appears to me to be a case of misaligned columns. We are already into April - it would be nice to close my books easily and quickly each month.

Thank you both for your help...

Hello hapa01,
Can you explain what the "pay service fees" are? I have seen this column, but I do not know what it is used for. Thanks

quote:

---

Originally posted by Ward:
Hello hapa01,
Can you explain what the "pay service fees" are? I have seen this column, but I do not know what it is used for. Thanks

---

Pay services are those such as Billpoint or PayPal that allow winners of your auction to use a credit card, check or balance in their account to pay you for an auction. They charge a commission for that, just like ebay charges you an insetion and final value fee. ebud does not automatically pick up pay service fees.....you have to enter them maually.

The problem with the pay services fees not being added to the gross expenses has been fixed for the next release.

I am unable to reproduce the error you mentioned above concerning the shipping prices. Are you able to reproduce this? If so, and if you don't mind, could you file a support case about it so i could grab some files from you to find out what's going on?

miles

Actually I think I've figured it out.

The total for the "shipping" column does not add in shipping charges on items that didn't sell, even though that amount shows up in the
"shipping" column because it was pulled from the spreadsheet, where it was automatically inserted when the aution was pulled in from ebay. Pretty neat for it to figure out that item didn't sell and not to add it into the total. However, in the "gross expenses" column the shipping for items that didn't sell is being added in. So if you add the totals for the "shipping" column, the "cost" column and the "ebay fees" column it doesn't match the total for the "gross expenses" column. It's off by the amount of shipping on unsold items.

Of course there is also still the problem of the pay sevice fees not being added into the "gross expenses" column, so it is wrong on two levels.

Also, are we ever going to be able to have a column on the report that shows the pay sevice fees instead of it being a "hidden" item? It would require being able have a selection for pay service fees under "Edit>Report Settings".

As i mentioned above, the pay service fees problem has been fixed and will be available in the next release. I'm not sure if a column will be added for it by then or not.

I should be able to figure out the shipping thing with the info you provided above, thanx!

miles

The problem is not just shipping - if you look at the line item of a single auction (see my info 11 postings ago - the gross expenses is not being subtracted at all from the net profit.
Miles - Brandon has an example that I sent to him via support, he is working on it as well, I don' want you to duplicate work. If we can get each line item to work - then the totals will also work.

quote:

---

Originally posted by jcrbfam:
The problem is not just shipping - if you look at the line item of a single auction (see my info 11 postings ago - the gross expenses is not being subtracted at all from the net profit.
Miles - Brandon has an example that I sent to him via support, he is working on it as well, I don' want you to duplicate work. If we can get each line item to work - then the totals will also work.

---

I'm not sure what you mean here.

Gross expenses shouldn't be subtracted from net profits. Gross expenses should be subtracted from gross receipts to get net profits.

Sorry, I just looked at your example in a previous post and I see what you mean. On my reports it's not doing that. My reports add the shipping to the bid amount to get gross receipts then subtracts them again (along with "cost" and "ebay fees" and "pay service fees") for net profit. Net profit column is correct.

[This message was edited by hapa01 on April 04, 2002 at 10:23 PM.]