Paypal login my account statement8/25/2023 In our example, this is £12.įrom the PayPal bank account, create a new Other Payment for the amount of the fees. ![]() Select the payment using the check box to the left.ĭiscard the payment using the Bin icon at the top of the page.įrom Banking, open the PayPal bank account and create a new Customer Receiptfor the total value of the invoice, and select the invoice to pay. From your bank feed, match the payment from PayPal with the remaining value of the sales invoice.ĭiscard the payment from the bank feed and create two new transactionsįrom Banking, open your PayPal bank account.Return to Banking and open your PayPal bank account.In our example, the amount outstanding on the invoice will be £10. This reduces the outstanding amount on the invoice. This could be Bank charges and interest or the new nominal account you have created. In our example, this would be for £2.Ĭhoose the category to record your PayPal fees. Open the sales invoice you want to pay from Sales, then Sales invoices.Įnter a line for the amount of the fee.Matching a credit to the invoice first, reduces the outstanding balance and allows you match the payment from PayPal. This could be Bank charges and interest or the new nominal account you have created.Įnter the amount of the fee. Select the Make adjustment option next to the Left to Match total.Ĭhoose the category to record your PayPal fees.In our example, this will match £12, leaving £2 left over. From the bank feed, choose Match on the payment from PayPal.This allows you record the payment and the fees directly from the bank feed at the same time. Paypal deducts a £2 fee, sending you £10. Match the payment from PayPal to the invoice from the bank feed and add an adjustment for the fee.Ĭreate a credit note for the amount of the fee, then match this and the payment from PayPal to the invoice.ĭiscard the payment from PayPal from your bank feed and create two new transactions a Customer Receipt for the full value of the invoice and an Other Payment for the fee. There are three ways to record money received from the customer and the fee charged by PayPal. You could record them using an existing category such as Bank Charges, or create new category specifically for PayPal fees.Īny new ledger account would need to be an created as an Overhead and be visible in both sales and purchases. Things to considerĬonsider where you want to record the fees paid to PayPal. This explains how to match these receipts to invoices. If you use QuickBooks, go to for instructions on how to download your transaction history directly into QuickBooks.PayPal (UK) is also supported via bank feeds however unlike a standard bank feed, transactions imported from PayPal already have fees deducted from each transaction. You can download Comma Delimited files as Excel Spreadsheets and Tab Delimited files as. Small logs are downloaded immediately and are not saved. We save the last 3 most recently completed, large History Log files. We will email you when your file is ready to be downloaded. Depending on the server load, download logs can take up to 5 business days to generate. ![]() When downloading a large History Log, you may experience a delay. All of the columns will be added together and show the total amount in the box under the last fee amount. Go to the top of the spreadsheet and hold the Shift button and then click the first amount in the column.Ĭlick Formulas at the top of the Excel window.Ĭlick AutoSum. (If you uncheck boxes it will allow you to filter out what you do not need.)Ĭlick the box directly below the last fee/ tax/ shipping amount to get the total amount of fees. If you click it there is a drop down with checked boxes. Click the number to highlight the entire row.Ĭlick Data at the top of the Excel window. Here's how to filter an Excel Spreadsheet:Ĭlick the row with all of the subjects ("Date", "Time", "Name", etc.). You can download a report of your transaction activity for up to the past 7 years into PDF, Quicken, QuickBooks, or as a CSV or TAB file.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |