![]() There is evidently logic in the program to verify the difference between gross and net amounts compared to the fee. receipt example), there remains a possibility that cannot be explored from what you’ve provided. Since some of your examples did not line up (different transactions in import file vs. I would be happy to change the column headings to something else if needed to make it work.Īfter extensive investigation, I can think of two possible explanations for your problem: ![]() Perhaps this would be simpler… Can someone tell me how, by using a CSV bank statement import like that shown in the last screenshot above, I can have the Gross Amount and Fees split as was done before (see my 2nd screenshot above in my posts since yesterday). The CSV file used is the same as in my earlier screenshot above. The first shows the result of an import in which the Fee is not being recognized now. The second screenshot in this thread (above) shows a recent import that worked as expected. If it would help, I could email it to support instead. The file originally had dozens of customer transactions, but I am not about to post that, so I left two in place and changed the customers names. I don’t know what you are talking about with regard to the screen shot of the file I’m trying to import because I did so on my previous post. It would also help if you could post an old CSV file that imported correctly (if you still have one). Please understand that to diagnose why you are having difficulty, we need to see the exact file you are trying to import and the exact bank rules you are applying, not descriptions of them or simulations or manipulated versions of them. Instead, you showed a receipt you claim was created from a PayPal CSV import (although you admitted later it wasn’t) and a bit of a spreadsheet that may or may not be related to transactions giving you problems (you didn’t say). In an attempt to help, I asked for screen shots of the file you’re trying to import and the bank rules you are applying. Given that no changes have been announced regarding imports, and my tests showing the import feature still working, it’s far more likely the change occurred elsewhere, producing a disconnect with your bank rules–the one thing about which you have shared nothing. But you also haven’t explained in sufficient detail what your exact process is for taking advantage of this “magic.” Yet your assumption is that Manager has somehow failed. I don’t intend to sound rude, but you are putting a lot of faith in some “magic” you think performed, but have shared nothing about what it was. A cynic would guess it might have been when you started having trouble. And you haven’t said when you started using the Easy downloads instead. ![]() Now you reveal you aren’t even dealing with PayPal. I spent time downloading and importing PayPal. Here, you highlight the difficulty when correct, detailed information is not provided. Actually, nearly all of my sales are now through an Etsy storefront and Etsy handles both my credit card and PayPal sales receipts. To avoid unnecessary complication in my most recent posts, I referred to the CSV file as my PayPal import file. This import process has worked great for the past two years and I would hate to lose this invaluable feature. Once the import into my cash account for checking is complete and the bank rules have been applied, I look for any PayPal payment transactions and manually allocate them to the cash account for PayPal. A screenshot showing the CSV column headings that I have used for the past two years is below. Some of Etsy’s column headings differ from PayPal’s, but, before doing an import, I manually change the headings to match that of the PayPal’s CSV file that was originally sent to lubos. Customer payments by credit card and PayPal are mixed together in the spreadsheet, but clearly identified. The rest are credit card transactions processed by an Etsy vendor.Īll my current sales transactions are now downloaded from Etsy in CSV format - the only option. PayPal accounts for only 15% of my sales payments. When I first communicated with him, I sent him a sample PayPal CSV and he apparently used those column headings to work his magic. I sincerely appreciate you taking the time to assist, but wonder at this point if it might be easier to have lubos address it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |