WikiBots
1,397
edits
Changes
From Pumping Station One
mLine 38:
Line 38: − Line 46:
Line 45: + − == Categorizing PayPal ==+ − Paypal is handled a little differently from the other accounts. We do not import individual transactions. Instead, we create journal entries from reports+ − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + − + − − many of the area hosts have provided helpful spreadsheets for tracking this information down. Line 83:
Line 130: + + + Line 117:
Line 167: − + − + + + + +
Bot: Cosmetic changes
* Verify that the month you want to import has not already been imported. Reimporting transaction data makes a quick mess in quickbooks.
* Verify that the month you want to import has not already been imported. Reimporting transaction data makes a quick mess in quickbooks.
* Export a single entire completed month only.
* Export a single entire completed month only.
* Log into quickbooks at [https://qbo.intuit.com/app/homepage]
* Log into quickbooks at [https://qbo.intuit.com/app/homepage]
* Upload the QBO file you downloaded from the pex site.
* Upload the QBO file you downloaded from the pex site.
== Categorizing PayPal ==
Paypal Income is handled a little differently from the other accounts. We do not import individual transactions. Instead, we create journal entries from reports
=== Get Report from paypal ===
* Log in to https://business.paypal.com/webapps/merchantreportingweb/page/fsr.form
* Log in to https://business.paypal.com/webapps/merchantreportingweb/page/fsr.form
* Select the completed month you want to export, and press "View Report"
* Select the completed month you want to export, and press "View Report"
* Once the report is generated, Press "Download" next to the pdf combo box.
* Once the report is generated, Press "Download" next to the pdf combo box.
* rename the Downloaded file from ''MonthlyFinancialSummery.pdf'' to ''paypal-YYYY-MM.pdf'' where YYYY is the 4 digit year, and MM is the 2-digit month
* Rename the Downloaded file from ''MonthlyFinancialSummery.pdf'' to ''paypal-YYYY-MM.pdf'' where YYYY is the 4 digit year, and MM is the 2-digit month
=== Create Journal Entry in Quickbooks ===
* Log in to quickbooks
* Click the '''+''' at the top of the screen >> Journal Entry
* Set the Journal Date to the last day of the month you are creating the entry for.
{| class='wikitable'
! PayPal Statment line
! Debit
! Credit
! Description
! Department
|-
|Payments recieved
|0.00
|'''Member Dues'''
|paypal member dues
|G&A
|-
|Refunds Sent
|'''Member Dues'''
|0.00
|paypal member dues - refunds
|G&A
|-
|Fees
|'''Bank Charges'''
|
|paypal member dues - paypal fees
|G&A
|-
|Dispute Activity
|'''Member Dues'''
|'''Member Dues'''
|paypal member dues - dispute activity
|G&A
|-
|''remaining balance''
|'''PayPal'''
|
|paypal member dues
|G&A
|}
* The paypal statement lists Debit's as negative. Take the absolute value.
* Ignore '''Transfers & withdrawals''' and '''Purchase activity''' for now, those are handled differently.
* Dispute activity may show up as a debit or a credit. Pay attention and make sure it matches in quickbooks.
* Dispute activity is usually $0.00, you can skip it if it is
== Resolving ==
== Resolving ==
Find the receipt in RT for each transaction.
Find the receipt in RT for each transaction, or in the area host spreadsheet
=== General Area ===
=== General Area ===
=== Cold Metals ===
=== Cold Metals ===
* [https://rt.pumpingstationone.org/User/Summary.html?id=378 RT:dba]
* [https://rt.pumpingstationone.org/User/Summary.html?id=378 RT:dba]
=== CNC ===
* [https://rt.pumpingstationone.org/User/Summary.html?id=7869 RT:ekobrucki]
== Category ==
== Category ==
* Software licenses
* Software licenses
** Going to categorize these as office expenses. The "Regs, licenses, and fees" account will be used for government dealings.
** Going to categorize these as office expenses. The "Regs, licenses, and fees" account will be used for government dealings.
* Maid Service
* Online ACH Payment 4970812665 To Cleaners (_######8663)
** We are currently categorizing this as an office expense.
** Flying Broomstick / Office Expense / G&A
* Checks
* Checks
** Office expenses.
** Office expenses.
* Bank detail Chase ACH Payments Monthly Fee
** Chase Bank / Bank Charges / G&A
* SMALL BUSINESS ICPAYMENT
** Chase Bank / Laser Cutter Loan / G&A
