How to financials: Difference between revisions

Browse history interactively

← Older edit

VisualWikitext

@@ Line 38: / Line 38: @@
 * 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.
 * Log into quickbooks at [https://qbo.intuit.com/app/homepage]
@@ Line 45: / Line 44: @@
 * Select File Upload
 * 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
+* 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.
+* 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 ==
-Find the receipt in RT for each transaction.
+Find the receipt in RT for each transaction, or in the area host spreadsheet
-many of the area hosts have provided helpful spreadsheets for tracking this information down.
 === General Area ===
@@ Line 73: / Line 130: @@
 === Cold Metals ===
 * [https://rt.pumpingstationone.org/User/Summary.html?id=378 RT:dba]
+=== CNC ===
+* [https://rt.pumpingstationone.org/User/Summary.html?id=7869 RT:ekobrucki]
 == Category ==
@@ Line 107: / Line 167: @@
 * Software licenses
 ** 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
 ** 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