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. | | * 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] |
Line 45: |
Line 44: |
| * Select File Upload | | * Select File Upload |
| * Upload the QBO file you downloaded from the pex site. | | * Upload the QBO file you downloaded from the pex site. |
− |
| |
| | | |
| == Categorizing PayPal == | | == 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 | + | 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 === | | === Get Report from paypal === |
Line 56: |
Line 54: |
| * 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 === | | === Create Journal Entry in Quickbooks === |
Line 62: |
Line 60: |
| * Log in to quickbooks | | * Log in to quickbooks |
| * Click the '''+''' at the top of the screen >> Journal Entry | | * 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 | + | * 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 |
− | | |
− | many of the area hosts have provided helpful spreadsheets for tracking this information down.
| |
| | | |
| === General Area === | | === General Area === |
Line 91: |
Line 130: |
| === 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 == |
Line 125: |
Line 167: |
| * 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 |